-- 1 select * from user where userId=105; -- 2 select * from user where name like '王%'; -- 3 select *from user where ename like '%a%'; -- 4 select *from user where personId like'110%'; -- 5 select *from user where credit > 400; -- 6 select *from user where city='上海'; -- 7 select *from user where sex ='女'; -- 8 select *from user where city<300 and sex='男'; -- 9 select *from user where city='上海' and sex='女'; -- 10 select city from user; -- 11 select *from user where city in ('长沙','深圳'); -- 12 select *from user where credit between 200 and 400; -- 13 select *from user where ename is null; -- 14 select *from user where name like'__'; -- 15 select *from user where ename not regexp 'o'; -- 16 select *from user where credit between 200 and 400;