Deleting specific words from records 4

sinbadly · Mar 20, 2006

Is it possible to ask the mysql to remove some phrase - like <a href="

for instance - from fields throughout the db, when there's other information in the field that I want to remain, please experts?

jpadie · Mar 20, 2006

i would use php for this.

r937 · Mar 20, 2006

Code:

update daTable
   set daField 
     = replace(daField
         ,'string to be removed','')
 where daField like
         '%string to be removed%'

sinbadly · Mar 21, 2006

Many thanks, rudy. It's a piece of coding that will be used often, I think. Very grateful.

sinbadly · Mar 21, 2006

Many thanks, Justin. Looks very interesting.

jpadie · Mar 22, 2006

Many thanks, rudy. It's a piece of coding that will be used often, I think. Very grateful.

indeed! I never knew this could be done!