Some of my customers are changing their email addresses. I have over 1000 alerts which need their email addresses changed. Not all alerts list customer's name in the header so I'm not 100% sure who receives each email unless I open a specific alert and look at email addresses.
Is there a way to change the email addresses for the alerts through the database? Specifically, can I do a job or something like a "Find email@example.com and Replace With firstname.lastname@example.org." I would like to do a bulk change/bulk changes for each entity that is changing their email address. Is that possible? If so, what commands and process would I use to make that happen?