advanced code snippet search

Posted By

iroybot on 05/20/10


Tagged

mysql sql search replace searchnreplace


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

iroybot


Search & Replace in MySQL DB

 / Published in: SQL
 

URL: http://jowra.com/journal/2006/03/suchen-und-ersetzen-in-mysql-datenbanken

SQL to alter field contents. linked article is in german.

Expand | Embed | Plain Text 
  1. UPDATE TABLE SET fieldname =
  2. REPLACE(fieldname, 'search', 'replacewith');

Report this snippet  

You need to login to post a comment.