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

[ad_1]

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

[ad_2]

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