advanced code snippet search

Posted By

randyjhunt on 05/16/09


Tagged

url replace find


Versions (?)

Who likes this?

5 people have marked this snippet as a favorite

ginoplusio
JustGreg
dantreacy
kubaitis
jackkeller


Find & Replace

 / Published in: MySQL
 
Expand | Embed | Plain Text 
  1. UPDATE table_name SET column_name = REPLACE(column_name, 'http:\/\/oldcontent.com', 'http:\/\/newcontent.com');

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: jackkeller on March 15, 2011

Fantastic snippet, saved me from having to hand transform around 3000 records! Thanks

You need to login to post a comment.