mysql 登录 匹配,mysql的高级匹配条件

1.模糊查询 like

_ 表示1一个字符

% 表示0-n个字符

mysql> select name from user where name like '_';

mysql> select name from user where name like '%a%';

mysql> select name from user where name like '%_%';

2.正则表达式 regexp

正则：^ $ [] * |

mysql> select name from user where name regexp '^a|t$';

mysql> select name from user where regexp '^[abc]';

mysql> select name from user where name regexp '^..$';

3.计算

/ % ()

mysql> select name,uid from user where uid%2=0;

mysql> update user set uid=uid+1 where id<=5;

mysql> select name,uid from user where id <=5;

mysql> update user set uid=uid-1 where id<=5;

mysql> select name,2020-age csnf from user where name="root";

4.查询结果在处理

avg 统计字段平均值

sum 统计字段之和

min 统计字段最小值

max 统计字段最大值

count 统计字段值的个数

mysql> select count(*) from user;

mysql> select count(name) from user;

mysql> select avg(uid) from user;

mysql> select min(gid) from user;

5.排序

order by 字段名

asc 升序 desc 降序

mysql> select name,uid from user where id<=15 order by uid;

mysql> select name,uid from user where id<=15 order by uid desc;

6.查询分组

mysql> select uid from user group by uid;

7.查询过滤 having

mysql> select name from user where uid > 5;

mysql> select name from user where uid > 5 having name="myslq";

8.限制查询行数 limit

mysql> select name,uid from user limit 3;

mysql> name,uid gid from user limit 3 3;