Replace using Select
Posted on 2014-10-30
I have a table called REPLACE_ITEMS. It has two columns called old_value, new_value
I would like to write a replace statement to cross reference the values from the table
in a table called ADDRESS I have a column called addr_1
I would like to run the replace statement against addr_1 cross referencing all possibilities from the REPLACE_ITEMS table.
Here is a scenario of what something would look like in the address table before and after:
The replace query would find "rd" in the replace_items.old_value and replace it with the replace_items.new_value of "Road"
OLD ............. 4101 test rd
NEW.............. 4101 test Road
the question: How would the replace update query be written?
Thanks in Advance!