Very handy function if you need to replace a string in your MySQL database tables.
UPDATE table
SET field = REPLACE(field, 'Old Value', 'New Value')
Reference
MySQL String Functions
http://dev.mysql.com/doc/refman/5.1/en/string-functions.html
Very handy function if you need to replace a string in your MySQL database tables.
UPDATE table
SET field = REPLACE(field, 'Old Value', 'New Value')
MySQL String Functions
http://dev.mysql.com/doc/refman/5.1/en/string-functions.html
If you found this article useful and would like to see more like it this please consider making a donation.