The following regular expression function can be used to strip HTML tags:
SELECT REGEXP_REPLACE(field, '<[^>]*>+', '') FROM table
It is very simple.
The following regular expression function can be used to strip HTML tags:
SELECT REGEXP_REPLACE(field, '<[^>]*>+', '') FROM table
It is very simple.
In which MySQL versions? Seems to not work on Siteground.
Both MySQL and MariaDB recent version will work.
Thank you! And here I created another column just to save the raw text. hahahaha