MySQL Query not getting accurate output

Question

I have three categories & subcategories in table. Category (adventure, rejuvenation, gourmet) AND sub_category(air, balloon etc.)

Now I am firing below query

select * from products where sub_category Like '%Air%' or 
sub_category Like '%Land%' and category = 'adventure' 
and type = 'experience' and status = 'active'

Now problem is it is also getting rows where category = Rejuvenation. Hence it should only get result where category = adventure

Note also that '%...' cannot use an index, so if there's any way you can avoid that, so much the better. — Strawberry
– Strawberry, Commented Aug 29, 2016 at 13:33

Jens · Accepted Answer · 2016-08-29 13:23:17Z

4

You have to use brackets arround the or Statements:

select * from products where (sub_category Like '%Air%' or 
sub_category Like '%Land%' )and category = 'adventure' 
and type = 'experience' and status = 'active'

answered Aug 29, 2016 at 13:23

Jens

69.6k15 gold badges107 silver badges133 bronze badges

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

Comments

Gregor · Accepted Answer · 2016-08-29 13:25:41Z

0

AND has priority over OR. That's why your query returns everything, that has a sub category like Air. You should update your query like this:

select * from products where (sub_category Like '%Air%' or 
sub_category Like '%Land%') and category = 'adventure' 
and type = 'experience' and status = 'active'

answered Aug 29, 2016 at 13:25

Gregor

6229 silver badges21 bronze badges

Collectives™ on Stack Overflow

MySQL Query not getting accurate output

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related