advanced code snippet search

Posted By

fugue on 06/22/07


Tagged

mysql


Versions (?)

Who likes this?

3 people have marked this snippet as a favorite

brent-man
umang_nine
ljayz


MySQL Replace function

 / Published in: SQL
 

A life-saver in an emergency, to do a search & replace directly on the database. Probably also a cause of aforementioned emergency for many people, so do have a backup ready for when it goes wrong.

Expand | Embed | Plain Text 
  1. UPDATE my_table SET my_field = REPLACE(my_field, 'test12345', 'test54321') WHERE my_field LIKE '%test12345%';

Report this snippet  

You need to login to post a comment.