Results 1 to 8 of 8
Thread: Help Please
Feb 22, 2013, 10:00 #1
- Join Date
- Mar 2011
- Manchester, UK
- 0 Post(s)
- 0 Thread(s)
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.You're Help Does Not Go Unnoticed, I have So Far Donated £25 GBP
To Cancer Research UK As A Thank You To All The SitePoint
Members That Have Helped Me In The PHP Forum Thank You!