MySQL Find and Replace
Wed, 19 Nov 2008 06:55:39
update TABLE set COLUMN = replace(COLUMN,"FIND","REPLACE");
Capitals are to be replaced with your environmental variables.
Cheers
Ryan Partington
![]()
tags: apache archive business charity climbing comic communication database email exchange family fm2008 gk hack hardware humour linux liverpool microsoft money music mysql network oes opensource outlook photo php pictures process project quote real_life review rss science security software thought tsm updates video webdev website windows
update TABLE set COLUMN = replace(COLUMN,"FIND","REPLACE");
Capitals are to be replaced with your environmental variables.
Cheers
Ryan Partington