Removing part of text in column based on find and replace query
Posted on 2009-05-06
I have table called products and field cdescription where my data is mix of text and some wiered tags which I want to remove.
For example, a record looks like:
cdescription = This is best book <input id="gwProxy" type="hidden">
I want this to become:
cdescription = This is best book
Similary query should remove <input id="gwProxy" type="hidden"> from all records in cdescription without disturbing text data.
Thanks for your help.