DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world
MYSQL - Column Copy With String Replacement
MySql snippet to copy a column in a table to another column, with some string manipulation. Create new_col before executing this segment.
UPDATE table SET table.new_col=REPLACE(table.old_col,'str2replace','replace_with_str');