The following regular expression function can be used to strip HTML tags:
SELECT REGEXP_REPLACE(field, '<[^>]*>+', '') FROM table
It is very simple.
MySQL: How to Strip HTML Tags
2 thoughts on “MySQL: How to Strip HTML Tags”
Leave a Reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
In which MySQL versions? Seems to not work on Siteground.
Both MySQL and MariaDB recent version will work.