next »

[jsp123]

mysql> update table_name set table_field = replace(table_field,'replace_that','with_this');

This will save me from writing a php script when I want to do this again.  Unless I need a regex...

[perkiset]

How funny ... that's why we have a code repository here, so that I can keep stuff I don't want to forget ever again.