Find & Replace SQL Query
Friday, July 11th, 2008It took me a while to work this out, so I’m posting it so I can find it later and anyone else looking for it might be able to make use of it.
UPDATE *table name* SET *column name* = replace( *column name*,'*find*','*replace with*')
Just alter the text within the asterisks (and remove those asterisks).