How to replace a string via MySQL command on all discussions?

AristaP · May 2017

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!

R_J · May 2017

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

How to replace a string via MySQL command on all discussions?

Answers