mardi 10 février 2015

Compare value with integer sqlite

Here is my database structure: http://ift.tt/1KJ8Jeq


I'm trying to make a select query:



SELECT * FROM QUESTIONS WHERE TEAM="Albania" UID!='2' LIMIT 1


But I get a syntax error:



near "UID": syntax error
﹕ android.database.sqlite.SQLiteException:
near "UID": syntax error (code 1): , while compiling: SELECT * FROM QUESTIONS
WHERE TEAM="Albania" UID!='2' LIMIT 1

Aucun commentaire:

Enregistrer un commentaire