title: extract details from mysql table data
body: <p>I have a mysql table which consists of 1000 records. In the content field there is an anchor tag and I want to extract the author name from this content field and insert it in author field of the same table.</p>
  
  <p>content is </p>
  
  <pre><code> &lt;p&gt;
      When air conditioning, escalators, and advertising appeared, shopping expanded its scale, but also limited its spontaneity. And it became much more predictable, almost scientific. What had once been the most surprising became the most manipulated.&lt;/p&gt; 
      &lt;p class="bq_fq_a"&gt; 
      &lt;a id="qut" title="rem_koolhaas"&gt; Rem Koolhaas &lt;/a&gt; 
      &lt;/p&gt; &lt;br&gt;
  </code></pre>
  
  <p>Here you can see that author is Rem Koolhaas. I want to extract the author and update author field in same table with this. In all cell there are different content but the format is same.All rows consists of anchor.
  in addition to that I have three more columns in that table tag1,tag2,tag3. I have 50 tags (like success,fun,morning,beach etc )which I want to match with this content and place them in tag1,tag2,tag3 if it matches</p>
  
  <p>table is  </p>
  
  <pre><code>  id    content            author     tag1   tag2     tag3
  
    1     as given above     blank      blank   blank   blank
  </code></pre>
  
  <p>any way to do this?</p>