Posted By

apphp-snippets on 02/04/14

Tagged

mysql
replace
find

Versions (?)

Last Edited at 02/04/14 09:22pm

Statistics

Viewed 1168 times

Favorited by 0 user(s)

Related snippets

Find and Replace with MySQL

/ Published in: MySQL

MySQL has a handy and simple string function REPLACE() that allows table data with the matching string to be replaced by new string. This is useful if there is need to search and replace a text string which affects many records or rows, such as change of address, company name, URL or spelling mistake.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

-- 1st example
UPDATE files SET filepath = REPLACE(filepath,'path/to/search','path/to/replace');
 
-- 2nd example
UPDATE customers SET address = REPLACE(address,'_CODE_',postcode);