line of code for "find & replace/delete"

fsctke · #1 (**permalink**) 01-15-07, 02:02

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?

r937 · #2 (**permalink**) 01-15-07, 03:51

Code:

update products
   set description = replace(description,'the phrase','')
 where description like '%the phrase%'

fsctke · #3 (**permalink**) 01-15-07, 03:55

ok thanks a million, i'll try that!

fsctke · #4 (**permalink**) 01-15-07, 10:35

Where abouts in this SQL code do I place the text to be replace ("Est.Retail Price") and where abouts do I enter the text that will replace it(" ")?

r937 · #5 (**permalink**) 01-15-07, 10:44

right there -- i showed you where, in post #2

look up the REPLACE function in the docs, and see which parameter is for what purpose

then try to see how the parameters that i used in post #2 correlate with what you're trying to do

it's all right there

Internet Services

Web Development

Digital Marketing

Consumer Tech