Sorry about constantly messing with the layout... I just nearly got done and they released an update to the software...

Find & Replace SQL Query

It 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).

Tags: ,

Leave a Reply