开发者

Find rows in table regexp - mysql

开发者 https://www.devze.com 2023-03-01 18:38 出处:网络
How to find rows in table which not co开发者_Python百科ntain @ symbol ?use NOT LIKE (\'%@%\')SELECT * FROM table_name WHERE column_name NOT REGEXP \'.*@.*\';

How to find rows in table which not co开发者_Python百科ntain @ symbol ?


use NOT LIKE ('%@%')


SELECT * FROM table_name WHERE column_name NOT REGEXP '.*@.*';
0

精彩评论

暂无评论...
验证码 换一张
取 消