Failed to get Columns Result From DB using 'like' in sqlite3 android?

Question

Here is my query that i am running but its returning me nothing even data exists in column i am trying to pass keywords mention by user and searching data in DB and providing result to the user.

My query is:

SELECT fatwa.question_id, question.ques_img_name 
FROM fatwa, question  
WHEREfatwa.fatwa_keywords LIKE "hadees" AND fatwa.question_id =question.id

While here is my Database: table image

try this `LIKE '%hadees%' in your query

M D
– M D

2014-02-22 18:58:05 +00:00
Commented Feb 22, 2014 at 18:58 — M D
– M D, Commented Feb 22, 2014 at 18:58

Dan Is Fiddling By Firelight · Accepted Answer · 2019-03-30 17:13:04Z

2

Execute your Query like:

SELECT fatwa.question_id, question.ques_img_name 
FROM fatwa, question  
WHERE fatwa.fatwa_keywords LIKE '%hadees%' AND fatwa.question_id =question.id

More information go to: sqlite_like_clause

edited Mar 30, 2019 at 17:13

Dan Is Fiddling By Firelight

6,07118 gold badges82 silver badges132 bronze badges

answered Feb 22, 2014 at 19:01

M D

47.9k9 gold badges96 silver badges116 bronze badges

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

2 Comments

user3233280 Over a year ago

can someone please respond me here stackoverflow.com/questions/21958529/…

user3233280 Over a year ago

actually i am getting id 2 and 3 from first function now i want to call 2nd function for id "2" then do somework for inside for loop and then then call 2nd function for id 3

Dan Is Fiddling By Firelight · Accepted Answer · 2019-03-30 17:14:09Z

1

Use single quote with like statement:

SELECT fatwa.question_id, question.ques_img_name 
FROM fatwa, question  
WHERE fatwa.fatwa_keywords LIKE '%hadees%' AND fatwa.question_id =question.id

question_id should be an integer.

edited Mar 30, 2019 at 17:14

Dan Is Fiddling By Firelight

6,07118 gold badges82 silver badges132 bronze badges

answered Feb 22, 2014 at 19:10

Amit Saxena

5967 silver badges18 bronze badges

2 Comments

user3233280 Over a year ago

can u pls see this stackoverflow.com/questions/21958852/…

user3233280 Over a year ago

stackoverflow.com/questions/21958529/…

Dan Is Fiddling By Firelight · Accepted Answer · 2019-03-30 17:14:48Z

1

Change your query to the following:

SELECT fatwa.question_id, question.ques_img_name 
FROM fatwa, question  
WHERE fatwa.fatwa_keywords LIKE '%hadees%' AND fatwa.question_id =question.id

you are not using like command properly.

edited Mar 30, 2019 at 17:14

Dan Is Fiddling By Firelight

6,07118 gold badges82 silver badges132 bronze badges

answered Feb 22, 2014 at 18:58

Rohan Kandwal

9,3268 gold badges77 silver badges112 bronze badges

3 Comments

M D Over a year ago

@RK check your query plz.

Rohan Kandwal Over a year ago

@ArtooDetoo Sorry wrote them in a hurry from a personal example. Editing now.

user3233280 Over a year ago

@RohanKandwal can u pls check this stackoverflow.com/questions/21958529/…

Collectives™ on Stack Overflow

Failed to get Columns Result From DB using 'like' in sqlite3 android?

3 Answers 3

2 Comments

2 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related