title: Unserialize through query at database level itself
body: <p>I have a column value stored in the database as:</p>
  
  <blockquote>
    <p>a:2:{i:0;s:2:"US";i:1;s:2:"19";}</p>
  </blockquote>
  
  <p>I want to unserialize it during the mysql query rather than using the php  <code>unserialize</code> function after fetching the data.
  I want to do it this way so I can join another table with the serialized value. This would avoid executing a separate query after unserializing it with php, just for the joined data.</p>