-
查询客户id是105的客户信息
-
查询王姓的客户信息
-
查询英文姓名包括字符 a 的客户信息
-
查询身份证号码以110开头的客户信息
-
查询信用积分大于400的客户信息
-
查询上海的客户信息
-
查询所有女性的客户信息
-
查询信用积分小于300的男性客户信息
-
查询上海的女性客户信息
-
查询客户分布在哪些城市
-
查询长沙和深圳两地的客户信息
-
查询信用积分大于200小于400的客户信息
-
查询没有英文名的客户信息
-
查询姓名是两个字的客户信息
-
查询英文名不包含字符o的客户信息
SelECt * from user where userId='105'
SelECt * from user where name like '王%'
SelECt * from user where ename like '%a%'
SelECt * from user where personId rlike '110.'
SelECt * from user where credit>400
SelECt * from user where city like '上海'
SelECt * from user where sex like '女'
SelECt * from user where credit<300 && sex like '男'
SelECt * from user where city like '上海' && sex like '女'
SelECt city from user
SelECt * from user where city like '长沙' || city like '深圳'
SelECt * from user where credit>200 && credit<400
SelECt * from user where ename =''
SelECt * from user where name like'__'
SelECt * from user where ename not rlike'o'
SelECt * from user where credit<200 && credit>400