SQL to Find Email Address When Only Having The Domain Name

Databases
1

Hi All

I have a table of email addresses that I send to and sometimes I get an auto response to update the email address to a new one.

The issue is that sometimes the email address that sends that is not the email address in the database.

Does someone know the SQL code to select all entries in the database with a specific domain name… I have Google this and am not having much luck.

FOR EXAMPLE

I have in my DB - joeblow@abc.com and an email comes back from info@abc.com… I want to find all entries with either @abc.com or just abc.com

Any help would be great.

mrmbarnes

2

SELECT email FROM emailtable WHERE email LIKE "%@abc.com"

3

Thank you so much… my syntax was just slightly off.

4

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.