Re: Removing HTML tags using mysql
Hi hartmut,
Actually, data already stored within mysql database with <html> tags.
as what we did while inserting it with rich editor.
we need to show data as it is inserted with keeping all <html> tags.
but if we do, strip_tags() , it will remove all the <html> tags and hence by this, no tags will be displayed.
I want to display as html also and need to remove <html> tags while searching into database.
and if i will do this at php level, then i need to fetch all the data into array, then need to apply strip_tags on array, then search in it, and the need to sort the data which more time consuming and not performance oriented.that is why i cannot do this at php level.
Is there any other solutions at database level?
Thanks & Regards,
Amit Sankhala