Exclude SQL statement

Question

How to exclude data from SQL database using SQL statement? My situation is that I have a user login on my profile page, where they can communicate with each other. I want to show all users, except themselves, who are in the SQL database.

Answer 1

Maybe just

SELECT *
FROM 
    Users
WHERE
    UserId <> @ThisUserId

Or using delta union ( EXCEPTkeyword in SQL Server, not sure about other RDBMS implementations)

SELECT *
FROM 
    Users

EXCEPT

SELECT *
FROM 
    Users
WHERE
    UserId = @ThisUserId

Answer 2

What about:

SELECT * FROM people WHERE person_id != $current_user_id

Answer 3

, , .

, , , , ( " " ), .

, , , , , , . - , . , ...

, .

, , "Email" "UnwantedEmail", "". , , "Email", "UnwantedEmail", :

SELECT Email.Address FROM UnwantedEmail
RIGHT JOIN Email ON UnwantedEmail.Address=Email.Address
WHERE UnwantedEmail.Address Is Null;

: -)

/

Answer 4

select * from Foo where UserName not in ('Rohan', 'Rohan friend', .....)

This is useful?

Answer 5

If you know what a unique user ID is, you can use something like this, for example:

SELECT * FROM usertable WHERE id!='myuserid'

What I am doing with one of my authentication scripts is to store information for the person who is currently logging into the system in a variable, so in PHP it will look like this:

SELECT * FROM usertable WHERE id!='check(id)'