I exported a list by querying the information_schema. I know there are other ways I could do this:
Export the table and use replace function in the file. Then recreate the table
Code the logic in PHP and make the changes via loop
Part of this is curiosity/learning, part of it is wanting to be able to make these changes quickly, part is for future use since this comes up sometimes if the DB columns were not named properly initially. Ideally, I would like this to be all contained within one .sql file that can be ran automatically during deployment.