jeudi 5 mars 2015

Not-greater-than in SQLite

I have a query that I want to filter out all the results if a column is 1 or greater (if it's 0, NULL, or empty, I want to keep it in the results).


So I thought I'd use !< per this page, but when I try



WHERE column_name !< 0


I get the error



'SQLSTATE[HY000]: General error: 1 unrecognized token: "!<"'


Is the tutorial page wrong? How else would I do this query?


Aucun commentaire:

Enregistrer un commentaire