Your Ad Here

advanced code snippet search

Posted By

springy on 07/06/11


Tagged

mysql


Versions (?)

Find and replace a string

 / Published in: MySQL
 

URL: http://www.mediacollege.com/computer/database/mysql/find-replace.html

remove the square brackets

Expand | Embed | Plain Text 
  1. UPDATE [table_name] SET [field_name] = REPLACE([field_name],'[string_to_find]','[string_to_replace]');

Report this snippet  

You need to login to post a comment.