Android SQLite - Match multiword string

Question

I have a row in mytable with this value '{"test":"Hello World"}' in column1.

If I search the database with

SELECT * 
FROM mytable 
WHERE column1 LIKE '%Hello World%'

I get nothing. If I change the query to

SELECT * 
FROM mytable 
WHERE column1 LIKE '%Hello%'.

I get results but this is not what I want because this returns unwanted rows.

Is something wrong with the space character between the two words?

My code looks like this:

Cursor cursor=db.rawQuery("SELECT * FROM mytable WHERE column1 LIKE '%Hello World%'",null);
if(cursor.moveToFirst()) {
    while(cursor.moveToNext()) {
        //log results
        ...
    }
}

Go to this link: [http://thinkdiff.net/mixed/sqlite-space-within-string/](http://thinkdiff.net/mixed/sqlite-space-within-string/) for just information — M D, Feb 25 '14 at 11:38
Try that query in sqlite browser and see the results are coming or not.. — Vamshi, Feb 25 '14 at 11:43

score 1 · Accepted Answer · answered Feb 25 '14 at 12:05

1

if(cursor.moveToFirst()) {
    while(cursor.moveToNext()) {

Code like this will skip the first row. Instead, do it like this:

if (cursor.moveToFirst()) {
    do {
        //...
    } while (cursor.moveToNext());
}

answered Feb 25 '14 at 12:05

laalto

150,114
66
286
303

score 0 · Answer 2 · edited May 23 '17 at 12:03

0

First of all the

SELECT * FROM mytable WHERE column1 LIKE '%Hello World%'

works for me in SQLite Database Browser (http://portableapps.com/apps/development/sqlite_database_browser_portable).

you can use the trim function as well:

Android SQLite SELECT Query

edited May 23 '17 at 12:03

Community

1
1

answered Feb 25 '14 at 12:02

voodoo98

175
2
4

Android SQLite - Match multiword string

2 Answers2