SELECT name FROM user WHERE NOT (name REGEXP "[\u0391-\uFFE5]");
SELECT name, length(name), char_length(name) FROM user;Mysql中查询汉字
snowtank
这个人很懒，什么都没留下
SELECT name FROM user WHERE NOT (name REGEXP "[\u0391-\uFFE5]");
SELECT name, length(name), char_length(name) FROM user;snowtank
这个人很懒，什么都没留下
文章评论