Find rows in table regexp - mysql

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

use NOT LIKE ('%@%')

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