Using Wildcards

[tewari68]

Hi,
I have a table with email addresses list which have been blocked by the users.
When an email comes in I have to run a check against that black listed emails and see if the from address of the email is balck listed or not.
The entries in the table could be like a.b.*@yahoo.com or ab@yahoo.com or any other such combination.
I need some help in designing a query which retrieves all such combinations I am not sure how to write the query to retrieve addresses like a.b.*@yahoo.com or *.a.b@yahoo.com.

Appreciate any help.

Thanks,
Tewari

 

[mbrooks]

Use MySQL's wildcard character %

SELECT ... FROM ... WHERE  column LIKE [i]'%.a.b@yahoo.com'[/i]

M. Brooks

http://mbrooks.info

 

[tewari68]

hi mbrooks, there could also be an entry like a.b.*@yahoo.com or *@yahoo.com.
I wouldn't know how many dots are there in the local part of the emailaddress

 

[guelphdad]

I'm not sure why you don't just compare the current string with your blacklisted addresses.

If I register as
a.b.smith@yahoo.com
and you have a blacklisted address of
absmith@yahoo.com
they aren't really the same are they? So then you are going to prevent me accessing the site when someone else is blacklisted?

 

[tewari68]

Hi guelphdad, that's exactly the problem that I am running into, and not sure how to write a single query to overcome this problem, somebody could blacklist a.b.*@yahoo.com whereas another can block just one specific address a.b.c@yahoo.com so I have to check for both these entries and pick up the right one. I am doing all this in C++.