create table t1 (pk int primary key, a int); insert into t1 values (1,1),(2,2),(3,3),(4,4); alter table t1 engine=S3; select a from t1 where pk in (2, 3); a 2 3 drop table t1;