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?

Answer 1

You just have to use IN operator

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

Answer 2

Use IN operator ex.

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

Answer 3

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.