Posted By

Jamie on 02/25/10


Tagged

mysql path replace find


Versions (?)

Who likes this?

10 people have marked this snippet as a favorite

fackz
d0ri0
dantreacy
jackkeller
jearley
kubaitis
mikael12
virendrakryadav
jeremydouglass
bug5


MySQL Find and Replace


 / Published in: MySQL
 

This is useful for when a Wordpress environment goes live; typically the uploads have an absolute URL.

  1. UPDATE files SET filepath = REPLACE(filepath,'path/to/search','path/to/replace');

Report this snippet  

You need to login to post a comment.