extract details from mysql table data -

i have mysql table consists of 1000 records. in content field there anchor tag , want extract author name content field , insert in author field of same table.

content

 <p>     when air conditioning, escalators, , advertising appeared, shopping expanded scale, limited spontaneity. , became more predictable, scientific. had once been surprising became manipulated.</p>      <p class="bq_fq_a">      <a id="qut" title="rem_koolhaas"> rem koolhaas </a>      </p> <br> 

here can see author rem koolhaas. want extract author , update author field in same table this. in cell there different content format same.all rows consists of anchor. in addition have 3 more columns in table tag1,tag2,tag3. have 50 tags (like success,fun,morning,beach etc )which want match content , place them in tag1,tag2,tag3 if matches

table

  id    content            author     tag1   tag2     tag3    1     given above     blank      blank   blank   blank 

any way this?

mysql doesn't have facility of interacting html..can specify language..

it can done writing these 2 lines.

  <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.10.1/jquery.min.js"></script>   <script> $(document).ready(function(){    var = $('#qut').html();    alert(a); }) </script>