Quote:
Originally Posted by Aneurysm
Does anyone have a link to a good guide/tutorial for Manual SQL queries?
I would like a reference to learn from but my specific problem is with yahoo and aol thinking that everything is SPAM so what I want to do is turn off admin emails and subscription emails to all @aol and @yahoo addresses. Also is there a wildcard I can use to get all the Yahoo addresses at the same time (.com .fr. uk etc...)
|
You really cannot go past the mysql documentation
http://dev.mysql.com/doc/refman/5.0/en/index.html
as for your specific question, mysql supports a regex search, but you can get away with using like
[sql]
select userid from user where email not like '%yahoo%';
[/sql]
As to where in the the code you put the check...that would take some hunting around.