advanced code snippet search

Posted By

mikael12 on 10/14/10


Tagged


Versions (?)

Who likes this?

4 people have marked this snippet as a favorite

bobbym245
takel
virendrakryadav
wirenaught


Mysql replace

 / Published in: MySQL
 
Expand | Embed | Plain Text 
  1. # Replace string in all records from a table
  2. UPDATE table_name SET column_name = REPLACE( column_name, '/dev', '' );
  3.  
  4. # Display a modified record set
  5. SELECT REPLACE( column_name, '/dev', '' ) FROM table_name;

Report this snippet  

You need to login to post a comment.