当前位置：首页 > 数据库 > 正文

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 ‘[u4e00-u9fa5]‘) order by id desc limit 60000;

上一篇
Linux服务器部署mysql5.7.x 二进制包

下一篇
mysql遇见contains nonaggregated column 'information_schema.PROFILING.SEQ'异常

相关文章

最新文章