title: MySQL search for text in html text field?
body: <p>There is a CKEditor field on our website which saves it's HTML to a text field in a MySQL database.  </p>
  
  <p>What I'm wondering is, if there is a function (regex for example?) that could strip out HTML tags when doing a LIKE match,</p>
  
  <p>e.g. so that searching for:</p>
  
  <p>like '%this is a test%'</p>
  
  <p>would find</p>
  
  <p>'this&lt;strong&gt;is&lt;/strong&gt;a test</p>
  
  <p>I get the feeling that it won't be practical/possible, but worth an ask!  </p>