Replacing values in mysql database

[dinheiro]

I am working on cleaning up a database. There is a field where there shouldn't be any html formatting whatsoever, but it does. Is there any possible way to get rid of html tags using the REPLACE function? For example, I would like to delete any <img /> tags and anything within them. Is that possible in SQL?

[adwatson]

Possibly - but I usually just create a perl or php script to do this kind of thing, especially as you can always run it again later if needed or modify it for other administrative tasks, set it up on a cron job, etc.

[longneck]

specifically to remove <img /> tags and paired tags? not easily. you could do simple tags like <br />.

i agree with adwatson: this is better accomplished by a simple PHP or Perl script.

[dinheiro]

Yeah. I'll just use RegEx to clean up within my scripts. I just didn't want to have to use up the extra memory needed to run regex on each record on outout. Thanks!!