dimanche 8 février 2015

sqlite AND NOT on same attribute

I am trying to use the WHERE clause along with AND NOT. My problem is that I have 10 different values of the same column that I do not want to select. An example of my problem is as follows:



select * from myTable WHERE state NOT 'FL' AND state NOT 'TX' AND state NOT
'WY' AND state NOT 'MI' AND state NOT 'CA' AND state NOT 'IL' ... and so on


I come up with a syntax error near 'FL'

Is there an easier way to do this since they are all coming from the same attribute?


Aucun commentaire:

Enregistrer un commentaire