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 ?