Mysql select Query with multiple conditions of same column

Question

I need MySQL select query like

select wt_id,wt_name from work_type where cat_id=1,2,5..;

Is it possible?

starko · Accepted Answer · 2014-12-23 12:09:43Z

3

Use IN operator ex.

... where cat_id IN (1,2,5..)

answered Dec 23, 2014 at 12:09

starko

1,14911 silver badges26 bronze badges

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

Comments

Saharsh Shah · Accepted Answer · 2014-12-23 12:08:41Z

2

You just have to use IN operator

SELECT wt_id, wt_name 
FROM work_type 
WHERE cat_id IN (1,2,5..);

answered Dec 23, 2014 at 12:08

Saharsh Shah

29.1k9 gold badges53 silver badges85 bronze badges

This result works as ORed query.. What about ANDed queries? Can u refer to this link

Chetan · Accepted Answer · 2017-05-09 07:13:58Z

0

You can use SQL IN operator.

SELECT wt_id, wt_name FROM work_type WHERE cat_id IN (1,2,5..);

If you have any question please comment below.

answered May 9, 2017 at 7:13

Chetan

516 bronze badges