How to replace a string via MySQL command on all discussions?
AristaP
New
Hi,
I would need a bit of help with a MySQL command, please.
I need to find the string abcd.com in all discussions and replace it with the string wxyz.com
I believe the best way to achieve this is via SQL command in phpMyAdmin or so... unless there is a plugin able to do the same.
Thank you!
1
Answers
You replace things in MySql by using MySqls replace command
https://dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_replace
You would have to replace in the column "Body" of the tables GDN_Discussion and GDN_Comment