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

Snippets has posted 5883 posts at DZone. View Full User Profile

MYSQL - Column Copy With String Replacement

08.20.2008
| 5215 views |
  • submit to reddit
        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');