MyBB Community Forums

So, I wrote a script for someone to create a huge SQL insert query for a huge list of emails. However, after running it, all emails show up like this

[email protected],

with a comma at the end, as I forgot to delete it in the script.

Is there any quick way to update all the addresses to get rid of all the commas via phpMyAdmin or will I have to delete all the rows and reinsert them?

Here you go:

update mybb_users set email = replace(email, ',', '');

Yeah, I just found it on stackoverflow. Thanks anyways