samedi 4 avril 2015

sqlite syntax error with case expression

I wrote a query as



SELECT case when "Whether you like it or not" = 1 then 'I like it' from myrestaurants;"



the sqlite said Error: near "from": syntax error I have tried different combinations with the case statement, but none of them worked.


Aucun commentaire:

Enregistrer un commentaire