[SOLVED] getting only HOTMAIL users' emails and NOT Yahoo?

[samoi]

Hello guys!

 

I have users in my db, but I need to bring up only the hotmail users only and not any other users! from their emails!

 

So I went with this but I'm stuck !:

$SQL = 0 ; // the query to pull up the ALL emails!
while($row = mysql_fetch_row($SQL)) {//there are emails
$emails = preg_replace('/([\w-\.]+)@(hotmail).([a-zA-Z]{2,4}\.[a-zA-Z]{2,4}|[a-zA-Z]{2,4})/','\1@\2\3',$row[0]);

echo $emails;
}

 

 

 

[samoi]

BTW, I only know how to deal with preg_replace!

I have no idea about the complicated preg_match_all() func!

[corbin]

What do the rows coming from the query look like?  Are they individual email addresses or chunks of text containing multiple?

[RussellReal]

SELECT * FROM table WHERE LOWER(email) REGEXP '[^@]+@hotmail.com$'

[.josh]

don't even need sql regex...

 

select * from table where email like '%@hotmail.com'

[.josh]

BTW, I only know how to deal with preg_replace!

I have no idea about the complicated preg_match_all() func!

 

all of the preg_xxxx functions use the same pcre regex engine.  If anything, preg_replace is the more complicated one, as it allows you to eval the replacement.

[RussellReal]

don't even need sql regex...

 

select * from table where email like '%@hotmail.com'

 

well, obviously, but this is a regex forum so I tried to keep up

[cags]

The OP didn't specify they wanted Hotmail.com e-mail addresses, they specified Hotmail addresses (which I assume would include .co.uk and any other variants, especially looking at the OPs Regex). Obviously you could use SELECT * FROM TABLE WHERE `email` LIKE '%hotmail%', but this would match an email address of hotmail_sucks@yahoo.com (prepare to be found by a spambot crawler if you own that address), which I assume is not wanted. Regex certainly seems the way forward.

[RussellReal]

The OP didn't specify they wanted Hotmail.com e-mail addresses, they specified Hotmail addresses (which I assume would include .co.uk and any other variants, especially looking at the OPs Regex). Obviously you could use SELECT * FROM TABLE WHERE `email` LIKE '%hotmail%', but this would match an email address of hotmail_sucks@yahoo.com (prepare to be found by a spambot crawler if you own that address), which I assume is not wanted. Regex certainly seems the way forward.

 

RIGHT ON

 

SELECT * FROM table WHERE email REGEXP '[^@]+?@hotmail\.[a-z.]{2,5}'

[abazoskib]

don't even need sql regex...

 

select * from table where email like '%@hotmail.com'

 

That's exactly what I use, but would regex be faster in MySQL?

[abazoskib]

The OP didn't specify they wanted Hotmail.com e-mail addresses, they specified Hotmail addresses (which I assume would include .co.uk and any other variants, especially looking at the OPs Regex). Obviously you could use SELECT * FROM TABLE WHERE `email` LIKE '%hotmail%', but this would match an email address of hotmail_sucks@yahoo.com (prepare to be found by a spambot crawler if you own that address), which I assume is not wanted. Regex certainly seems the way forward.

 

RIGHT ON

 

SELECT * FROM table WHERE email REGEXP '[^@]+?@hotmail\.[a-z.]{2,5}'

 

That returns

 

ERROR 1139 (42000): Got error 'repetition-operator operand invalid' from regexp

[RussellReal]

I think maybe mysql doesn't support lazy repetition. just remove the ? from after the +

[RussellReal]

oh!! you could also do something like this:

 

SELECT * FROM table WHERE email LIKE '%@hotmail.%'

 

haha coz you can't have @ in your name in an email so that should always be accurate