mySQL: Column copy with string replacement - A mySql snippet to copy a column in a table to another column, with some string manipulation.<br />

Quick Search:

mySQL: Column copy with string replacement

Jump to:

Category: >> mySQL >> Column copy with string replacement

<< last

next >>

Snippet Name: Column copy with string replacement

Description: A mySql snippet to copy a column in a table to another column, with some string manipulation.
Create 'new_col' before executing this segment.

Comment: (none)

Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

UPDATE TABLE SET TABLE.new_col=REPLACE(TABLE.old_col,'str2replace','replace_with_str');