MySQL SELECT query

[Woodburn2006 0]

i am trying to get results from a DB where you search for a false condition.

for example, if i wanted to search for a 21 year old in my table, i would use: Select from tablename where age='21'

but what i want to do is search for everybody who is not 21. so the code would be something like this: SELECT FROM tablename WHERE (age is not equal to)21

hard to explain but if anybody has any ideas then please let me know
thanks

[AV1611 0]

where age <> '21'

or where age not like '21'

or where age != '21'

or where age >= '22' AND age <= '20'

[.josh 1,417]

select * from table where age != 21