Mysql select Query with multiple conditions of same column

1.8k Views Asked by At

I need MySQL select query like

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

Is it possible?

3

There are 3 best solutions below

1
On BEST ANSWER

You just have to use IN operator

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

Use IN operator ex.

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

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.