Stripping HTML from db content

[Andrew Hazen]

Hi,

 

Does anyone know of a quick bit of query script using regular
expressions or the 'replace' string function to strip HTML tags from
databased content??

 

My site search queries are having indigestion with the rich html content
we are storing, because of all the strings in <img  tags etc.

 

I want to be able to do something like "select from table where
replace(regexp '<*>','',field) like 'search string'"

 

Any help would be appreciated.

 

Thanks.

 

Andrew Hazen, O.C.P.

E-Commerce Developer

Jatech Solutions Inc.

www.jatech.ca

Specializing in OSCOMMERCE applications and PHP/MySQL programming.