I have a MySQL table with a description column. This description contains rich text and is stored in html format.
To search text purposes, I have added another field which I want to contain the plain text version of this html text, so I will create a trigger that fills/updates this new field when a row is inserted or when the html field is updated.
My question is how can I decode the HTML. I have found a code to create a function to strip tags, but I don't know how can I convert html special characters to text (for example UTF-8 encoded). I know this is easy in php but I need to do it on mysql trigger so I need a mysql way to made this conversion.
Is this possible ?