Gossamer Forum
Home : Products : DBMan SQL : Discussion :

Find & Replace

Quote Reply
Find & Replace
Easy Question? Hard Answer!

I am trying to do a find a replace in a field on a database.

For example is a field i have

"the cow jumped over the moon" in one record and "the moon comes out at night" in another

I want to find each instance of the word moon and replace it with the word sun - how do i do this using mysql monitor?
Best Regards
Marc P Summers
Canterbury City Council
Subject Author Views Date
Thread Find & Replace MarcPSummers 2801 Dec 21, 2001, 1:50 AM
Post Re: [MarcPSummers] Find & Replace
MarcPSummers 2686 Dec 21, 2001, 2:07 AM