why rawQuery is working and query isn't working?

Question

I am using query for search but i don't understand why one code is work and another one not work ?!

this is working:

          String selectQuery = "SELECT  * FROM " + TABLE_Soras
                               +" WHERE "+KEY_SoraName+" LIKE '%"+soraName+"%'";
          Cursor cursor = db.rawQuery(selectQuery,null);

but this isn't get any result:

    Cursor cursor = db.query(TABLE_Soras, new String[]{
             KEY_SORA_NO, KEY_SoraName}, KEY_SoraName + "=?",
            new String[]{soraName}, null, null, null, null);*/

Basically in second query you are asking where `KEY_SoraName = soraName` not using like so you will get result only if they are equal. — Rohan Kandwal, Dec 19 '13 at 12:34
yes that's right in the database there is some spaces after the word so like is working — amorenew, Dec 19 '13 at 13:39

score 2 · Accepted Answer · answered Dec 19 '13 at 12:29

2

Because in second case % is not appended into value and you didn't add LIKE clause into query. You need to use this:

KEY_SoraName + " like ?", new String[] {"%" +soraName + "%"} ...

answered Dec 19 '13 at 12:29

Simon Dorociak

33,374
10
68
106

score 0 · Answer 2 · answered Dec 19 '13 at 12:29

0

Try this

Cursor cursor = db.query(TABLE_QuranSoras, new String[]{
             KEY_SORA_NO, KEY_SoraName}, KEY_SoraName+" LIKE '%"+soraName+"%'", null, null, null, null);

answered Dec 19 '13 at 12:29

Sanket Shah

4,352
3
21
41

score 0 · Answer 3 · answered Dec 19 '13 at 12:30

0

Cursor cursor = your_database.query(MY_TABLE, new String[] {"first_column","second_column"},your_column + " LIKE '%"+your_criteria+"%'", null, null, null, null);

Try something like this and it will probably work!

answered Dec 19 '13 at 12:30

Pavlos

2,183
2
20
27

why rawQuery is working and query isn't working?

3 Answers3