[Solved] Mysql select all users except users with @example1.com and @example2.com mails

by


If you need to exclude multiple domains that are not name similarly then do this – 

SELECT * 
FROM `table`
WHERE `email` NOT LIKE '%foo%'
AND `email` NOT LIKE '%bar%'
AND `email` NOT LIKE '%baz%'

0

solved Mysql select all users except users with @example1.com and @example2.com mails