PROS! A MySQL query which should be simple...

[brianb]

Hello people,

I have a table in my MySQL database which has a 'text' field that holds a bunch of data about a certian product...

Inside certain entries in, this text field contains valuble product info, but also some HTML code which I want to get rid of in every instance in my DB.

Make sense?

So, how would I delete a specified chunk of HTMl from a certain field, via a MySQL query?

Any coding example are appreciated!

Thanks!

[brianb]

Anyone have any ideas on this?

[jophus]

what about writing a small PHP script and updating the field with strip_tags($field_value)... That should get rid of the tags and should solve the problem... However it is not a nice little SQL Statement... But it solves the problem ;o)

Jophus