Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Script Library
 line of code for "find & replace/delete"

Author  Topic 

fsctke
Starting Member

1 Post

Posted - 2007-01-14 : 01:07:26
I have mysql type db in which I need computer to search for a key phrase of text that has several hundred occurances inside product table descriptions of products on live site. Once it finds the text, I would like for it to simply remove it, and look for the next occurance of the phrase and repeat the process until all are flagged and removed. I was told their may be a line of sql code that employs such a feature. Can anyone tell me what such a line would be?

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-01-14 : 13:53:07
this forum is for ms sql only. try http://www.dbforums.com for mysql questions.


www.elsasoft.org
Go to Top of Page
   

- Advertisement -