I have a ton of rows in the database that, in the entry column, are similar to this:
“Set to bouncing due to a hard bounce from exampleEmailAddress@yahoo.com.”
I am trying to remove the email address so that the column just looks like this:
“Set to bouncing due to a hard bounce.”
What do I put in where the question marks are to make this query work?
UPDATE notesOnline SET entry = REPLACE(entry,’???’,‘Set to bouncing due to a hard bounce.’) WHERE entry LIKE ‘Set to bouncing due to a hard bounce%’;