Praveen's Blog

An Eternal Quest for Incremental Improvement

The following query will be handy if one likes to search and replace a string in a particular column.

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