Mysql中查询汉字

2017-11-22 0条评论 642次阅读 0人点赞

SELECT name FROM user WHERE NOT (name REGEXP "[\u0391-\uFFE5]");

SELECT name, length(name), char_length(name) FROM user;