I need some help please.
I have a table called Emails and a table called BadList.
In the table Emails it has 1 field called EmailAddress which has over 300,000 email addresses.
In the table BadList it has 1 field called Domain which has around 500 domains like "@123.co.uk".
I'm not sure how to do what i need to do so I need your help please. I need a MySQL Query that will list all the email addresses found in the table Emails that match any of the domains listed in the table BadList.
I know your going to have to use the WHERE EmailAddress LIKE '%BadListValue%'
If anyone could help me that would be great.