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] :中文以外的字符
文章乃参考、转载其他博客所得,仅供自己学习作笔记使用!!!