MYSQL select, exclude certain results

[jayke00]

Hey,

I was wondering if its possible to query the database but exclude certain information. I'm wanting to search a table for all the users I have, but exclude a single user from that search. What im wanting is an 'exclude' option:

select * from table where user_info='user_info' exclude user_id='user_id'

Does anyone know how I could do this, or if it's even possible.

Thanks :)

[pyro]

Yeah, you use something like this:

$sql = "SELECT * FROM `tablename` WHERE `fieldname` != 'something'";

[jayke00]

Perfect!

Thanks :)

[pyro]

You bet... :)