Android SQLite Like query

Question

The following Query works Fine in my app

db.query(true, DATABASE_TABLE, new String[] {KEY_ROWID,KEY_FAULTREF,KEY_WORKNUM,KEY_ORIGNUM,KEY_REPBY,KEY_REPDATTIM,KEY_DESCRIPTION}, KEY_FAULTREF + "='" + strname+ "'", null,null, null, null, null);

strname is what I am searching for but it will only bring back records that EXACTLY match this

I want to modify so it brings back everything that CONTAINS strname (eg something like strname)

I tried the following but my app crashed

db.query(true, DATABASE_TABLE, new String[] {KEY_ROWID,KEY_FAULTREF,KEY_WORKNUM,KEY_ORIGNUM,KEY_REPBY,KEY_REPDATTIM,KEY_DESCRIPTION}, KEY_REPBY + "LIKE %'" + strname+ "'%", null,null, null, null, null);

I know its the LIKE statement but any ides where im going wrong?

Your help appreciated

Mark

could you post the logcat.

Uma Kanth
– Uma Kanth

2015-05-29 07:27:04 +00:00
Commented May 29, 2015 at 7:27 — Uma Kanth
– Uma Kanth, Commented May 29, 2015 at 7:27

CL. · Accepted Answer · 2015-05-29 08:08:36Z

6

The % wildcards must be part of the string:

... + " LIKE '%" + strname+ "%'", ...

Please note that this code will blow up when the string contains a quote. You should use parameters instead:

db.query(true, DATABASE_TABLE,
         new String[] {KEY_ROWID,KEY_FAULTREF,KEY_WORKNUM,KEY_ORIGNUM,KEY_REPBY,KEY_REPDATTIM,KEY_DESCRIPTION},
         KEY_REPBY + " LIKE ?",
         new String[] { "%" + strname + "%" },
         null, null, null, null);

answered May 29, 2015 at 8:08

CL.

182k18 gold badges241 silver badges282 bronze badges

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

Collectives™ on Stack Overflow

Android SQLite Like query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related