SQLiteException: near "ORDER": syntax error (code 1):

0

My select code:

database.query("palavras",new String[]{"_termo"},"LIKE %?%",new String[]{nomeB}, null,null, "_termo ASC");

When making an appointment I get the following error: logcat:

  

Caused by: android.database.sqlite.SQLiteException: near "ORDER": syntax error (code 1):, while compiling: SELECT _termo FROM words WHERE LIKE%?% ORDER BY _termo ASC

I think it's a syntax error, but I'm not identifying it.

    
asked by anonymous 23.05.2018 / 02:49

0 answers