drop table if exists t1; create table t1 (id int(10) primary key); insert into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9); select id from t1 where id in (2,5,9) ; id 2 5 9 select id from t1 where id=2 or id=5 or id=9 ; id 2 5 9 drop table t1;