java - 将值与整数 sqlite 进行比较

Question

这是我的数据库结构:http://prntscr.com/63ftac

我正在尝试进行选择查询:

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

但是我收到语法错误:

 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

Answer 1

您错过了和:

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