title: how to remove html tags and php serialization info from mysql result without php?
body: <p>I'm storing a PHP array where key=>value pairs are information used to build jQuery UI tabs on a website.</p>
  
  <p>The string stored in the MySQL database looks like:</p>
  
  <p>a:2:{i:0;a:2:{i:1;s:9:"Info";i:2;s:643:"&lt;h2&gt;&lt;strong&gt;This section is about foo&lt;/strong&gt;&lt;/h2&gt;&lt;p&gt;&lt;strong&gt;Lorem ipsum ...";}i:1;a:2:{i:1;s:14:"More Info";i:2;s:465:"&lt;p&gt;Lorem ipsum ...";}}</p>
  
  <p>(not a valid serialized array or html because I truncated the lengthy content for formatting reasons)</p>
  
  <p>I would like to allow this content to be fed to Sphinx (full-text indexer) for site search purposes. Basically Sphinx just grabs the contents of the database and indexes what it finds, subject to the configuration options you specify... What I'm wondering is if there's a good way to get either MySQL or Sphinx to strip out the serialization information and html tags so that only the plain text gets indexed.</p>