Posted By

apphp-snippets on 02/04/14


Tagged

mysql replace find and apphp


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

Alex42195


Find and Replace with MySQL


 / Published in: MySQL
 

URL: http://www.apphp.com/index.php?snippet=mysql-find-and-replace

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.

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

Report this snippet  

You need to login to post a comment.