![]() |
Help wanted with Manual SQL Query
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...) |
Quote:
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. |
All times are GMT. The time now is 11:53 PM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|