Silver_2000_)!
07-09-2007, 10:11 PM
Im hoping someone here can help with a query
I have about 2200 users who were using AOL email addresses and the site owner decided he didnt want to deal with the bounces and issue swith AOL email so he banned AOL email for signups and also removed the AOL addresses from the user profiles - Which causes a diff problem - subscription emails that bounce because they have no send to email address -
So I need to either remove the subscriptions for the offending users or put logic in the email that checks for valid address before it sends
this query will select the 2200 users that have no email address
SELECT *
FROM `user`
WHERE `email` = CONVERT( _utf8 ' '
USING latin1 )
COLLATE latin1_swedish_ci
How do I remove the subscriptions for those users ?
Thanks in advance
Doug
I have about 2200 users who were using AOL email addresses and the site owner decided he didnt want to deal with the bounces and issue swith AOL email so he banned AOL email for signups and also removed the AOL addresses from the user profiles - Which causes a diff problem - subscription emails that bounce because they have no send to email address -
So I need to either remove the subscriptions for the offending users or put logic in the email that checks for valid address before it sends
this query will select the 2200 users that have no email address
SELECT *
FROM `user`
WHERE `email` = CONVERT( _utf8 ' '
USING latin1 )
COLLATE latin1_swedish_ci
How do I remove the subscriptions for those users ?
Thanks in advance
Doug