selecting the opsite

[canabatz]

how to select the oposite in mysql :

example :

select from 'my_table' where `username`='$username'

how can i select other users? not '$username'


like $username != $username

how im doing that in mysql?

[Atli]

Using != should work fine.

SELECT 1 = 1; /* Result: 1 */
SELECT 1 = 2; /* Result: 0 */
 
SELECT 1 != 1; /* Resutl: 0 */
SELECT 1 != 2; /* Resutl: 1 */
 

<> should also work

(See the manual)

[canabatz]

what i need is to select the other users ,not the current user.

is this ok:

select * from my_table where username <> $username ...?

[Atli]

Looks ok to me.

You could always just try it and see for yourself...