sql update string with value from other column
I want to update 750 rows of strings in a column [description] to include
the (city name) that is unique for each row. The city name is in the
[title] column and already in the string, but the city name has different
lengths, and I want to insert it into the middle of the description string
a second time.
[Title] [Description]
-------------------------------------------------------------------------
[Portland Web Design] [Our web design (insert 'Portland') office in
Portland ...]
[Seattle Web Design] [Our web design (insert 'Seattle') office in
Seattle ...]
How in the world?
No comments:
Post a Comment