Gossamer Forum
Home : Products : Gossamer Links : Discussions :

How to globally change part of a field?

Quote Reply
How to globally change part of a field?
Can someone tell me how to change part of a field in a table?

I want to change a phrase in description and url fields from "http://abaris.xxx.xxx/pages/...." to http://leto.xxx.xxx/pages/..." I only want to change wherever there is "abaris" to "leto" in SQL Monitor. Basically I am looking for an sql command to do that. Can someone tell me how to phrase it?

Thanks

Banana
Quote Reply
Re: [banana] How to globally change part of a field? In reply to
If you still need this:

UPDATE Links SET Field=REPLACE(Field,"old","new")

where old is the term that you want replaced and new is the replacement.