mysql-in

mysql-like


 select * from ROLE WHERE recordid in(17,18);

 select NAME from CUSTOMER WHERE name like '%name%';