Remove certain email addresses
 

Hello,

I have been trying to write a query to remove email addresses ending with yahoo.com in user profiles without removing the user.

Yahoo.com is blocking my emails, they are the only ones so I just want to remove the emails from user accounts so we get no more bouncebacks and to help me get those users to change the email addresses.

Thanks,
Rich

The query below will set the email to an empty string where the email ends with @yahoo.com.

Thank you Dave.

I had the exact same query minus the wildcard'%' but it would not work for me. Why is the '%' needed here?

Thanks, that worked perfectly.

Just a note regarding outgoing email.. Yahoo is not like the other services. If you have a sender score of lower than 80 you are most likely out of luck in getting through to yahoo addresses. It doesn't matter if your dns is set up perfectly.

If you do not include any wildcards at all, it will pretty much parse it as WHERE email = 'yahoo.com'. Wildcards simply state where in the string to look at.

Thanks Dave!