select*from user select*from user where userID='105' select*from user where name like '王%' select*from user where ename like '%a%' select*from user where personId like '110%' select*from user where credit>400 select*from user where city='上海' select*from user where sex='女' select*from user where credit<300 and sex='男' select*from user where sex='女' and city='上海' select city from user select*from user where city='长沙'or city='深圳' select*from user where ename='null' select*from user where not ename like '%o%' select*from user where credit<400 and credit>200