Brainfarts Uncategorized MySQL Statements

MySQL Statements

This post was most recently updated on December 11th, 2018

How to replace certain content in a MySQL database

 
String to use in MySQL:
update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’);
 
Example:
update mod_wysiwyg set content = replace(content,’84.27.217.110′,’www.bleuanus.nl’);

Related Post