sqlite query android exception

Question

please tell me what is wrong in this query:

getting following exception:

android.database.sqlite.SQLiteException: near "%": syntax error (code 1): , while compiling: SELECT _data, _size, media_type FROM files WHERE ( _size > 1048576 AND media_type = 0 AND _data LIKE %apk)

try this : select _data, _size, media_type from files where ( _size > '1048576' and media_type = '0' and _data like '%apk') — Hareshkumar Chhelana
– Hareshkumar Chhelana, Commented Sep 30, 2014 at 6:15

Rustam · Accepted Answer · 2014-09-30 06:14:12Z

3

try this:

SELECT _data, _size, media_type FROM files WHERE ( _size > 1048576 AND media_type = 0 AND _data LIKE '%apk')

answered Sep 30, 2014 at 6:14

Rustam

6,5151 gold badge27 silver badges25 bronze badges

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

Comments

Hareshkumar Chhelana · Accepted Answer · 2014-09-30 06:19:17Z

0

Try this way,hope this will help you ti solve your problem.

select _data, _size, media_type from files where ( _size > '1048576' and media_type = '0' and _data like '%apk')

answered Sep 30, 2014 at 6:19

Hareshkumar Chhelana

24.9k5 gold badges60 silver badges67 bronze badges

Comments

Md. Shahadat Sarker · Accepted Answer · 2014-09-30 06:24:53Z

0

I think you have missed the quote after like operator see this

edited Sep 30, 2014 at 6:24

answered Sep 30, 2014 at 6:16

Md. Shahadat Sarker

8499 silver badges16 bronze badges

Collectives™ on Stack Overflow

sqlite query android exception

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related