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 '.*@.*';
精彩评论