MYSQL - Column Copy With String Replacement
Join the DZone community and get the full member experience.Join For Free
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');
Strings MySQL Column (database) Data Types
Opinions expressed by DZone contributors are their own.