Display all records in table EXCEPT one.

[rapidz]

Ok, basically i'm trying to display all the records from a table with the exception of one record.

let's say the id for this record is 10.

How would i code it, so that it displays the rest of the records in the table called "USERS", but not the record with id 10.

Any help would be much appreciated.

Rapidz.

[mattyblah]

SELECT * FROM table WHERE id <> 10

That should work.