MySQL Replace String, Similar to PHP str_replace()

December 17th, 2008 | Posted in MySQL
0

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

Related posts

Leave a Reply