Sqlite Request Validation - Less and More

Question

return mDb.query(DATABASE_TABLE, new String[] { KEY_ROWID, KEY_LEVEL }, KEY_LEVEL + ">" + "=" + 3 + "<" + 5, null, null, null, null); 

What am I doing wrong. He returns to all levels above and is equal to level 3, but not less than 5. I tried && | etc.

Answer 1

 KEY_LEVEL + ">" + "=" + 3 + "<" + 5 

means

 KEY_LEVEL + ">=3<5" 

Use this instead:

 KEY_LEVEL + ">= 3 AND " + KEY_LEVEL + " < 5" 

Answer 2

Compare KEY_LEVEL with 3 and compare KEY_LEVEL with 5 with the union of two expressions. I have never seen SQL use && or || Operators use AND and OR.