Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
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