Php blog content search

recently, I am working on a blog system myself. The content of the article is saved using a ueditor editor, and the html tag will be added to the database
. Then here comes the problem
I want to search the plain text content in the article content, but if I use mysql"s where, I will search
together with the html tag. For example, I first published the article with 456, and then if the html code generated by ueditor is < p style= "width:100px;. "> 456

,
at this time, if I search for 100, this article will also appear. This is obviously unreasonable. Is there a better solution

?
Mar.02,2021

redundant one dedicated query.
however, if you usually use sphinx or es, blogs, then sphinx

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1b2b1fd-2ba68.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1b2b1fd-2ba68.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?