Hi Everyone,

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.

Thank you.