Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

SQL command is needed to globally change part of a field (not the whole field)

Nov 2, 2006, 8:48 AM
banana
User (164 posts)
Nov 2, 2006, 8:48 AM
Post #1 of 1
Views: 1526
Shortcut
Quote Reply
SQL command is needed to globally change part of a field (not the whole 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