sql - MySQL search for text in html text field? -


There is a CeEditator field on our website that saves an HTML data as HTML in the MySQL database.

What am I thinking, if there is a function (for example regex?) That can strip the HTML tag while matching the same,

For example, this search:

Like '% This is a test%'

will get

'this & lt; Strong & gt; Is & lt; / Strong> A test

I think it will not be feasible / possible, but be worth asking one!

I think your better bet is to touch HTML and store a plain-text version Do not use REGEX to delete the HTML as described by Ether in your database table when you do so.


Comments