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/ for just information — M D
– M D, Commented Feb 25, 2014 at 11:38
Try that query in sqlite browser and see the results are coming or not.. — Vamshi
– Vamshi, Commented Feb 25, 2014 at 11:43

laalto · Accepted Answer · 2014-02-25 12:05:15Z

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, 2014 at 12:05

laalto

153k68 gold badges293 silver badges306 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:03:41Z

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, 2017 at 12:03

CommunityBot

11 silver badge

answered Feb 25, 2014 at 12:02

voodoo98

1752 silver badges5 bronze badges

Collectives™ on Stack Overflow

Android SQLite - Match multiword string

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related