Mysql常用命令

1、匹配大写字母

select id from user where binary username regexp '[A-Z]';

2、匹配中文

select username from user where not(username regexp "[\u0391-\uFFE5]");