mysql 使用正则表达式查询

SELECT * FROM `qq` where qq_name!='no' and qq_gender='女' and qq_location!='no' and qq_location!='' and qq!=qq_name and LENGTH(qq_name)>4 and not(qq_name REGEXP '[u0391-uFFE5]') order by id desc limit 60000;

[u0391-uFFE5] :中文以外的字符

posted on 2018-04-20 14:30  神奇的旋风  阅读(227)  评论(0编辑  收藏  举报

导航