// post · 563
MySQL String Replace
Stuart just moved domains so we wanted to update his entries to link to the correct domain.
The following worked for us:
The following worked for us:
UPDATE table_name SET column_name = REPLACE(column_name,"original_string","replace_string");
// leave a comment
HTML allowed: <a href="" title="" rel=""></a> <b></b> <blockquote cite=""></blockquote> <em></em> <i></i> <strike></strike> <strong></strong> <li></li> <ol></ol> <ul></ul>
ie: <b>bold</b>
Your comment may need to be reviewed before it is published.
// comments