[Resolved] Select * But No This One

[spighita]

Hi:
I would like to know the proper statement for selecting everything but not this one.

Example:

Database has

state
id state_name
1 Florida
2 Colorado
3 Nevada
4 California

Now I would like to select everyone but Nevada for example.

SELECT * FROM state WHERE ........ NOT IN........

Thats where I'm confused.

Thanks in advance for anyone who helps.

[laserlight]

It depends.

In this case

SELECT * FROM state WHERE state_name<>'Nevada'

may suffice.

[spighita]

PERFECT, just what I needed.

Thank you

Now I will happily mark this thread resolved.