Wednesday
16
Nov 2005

Search and replace in MySQL

(9:40 am) Tags: [Sysadmin]

From padawan.info:

This made some data munging easy:

update tablename set field = replace(field,'search_for_this','replace_with_this');

Popularity: 17%

Comments: (1)