title: How to retrieve numerical data from BLOB column in WordPress database
body: <p>I have gone through to many discussions on BLOB but most of them are related to retrieving images from BLOB column but my requirement is to retrieve single data out of several binaries stored in the BLOB column.</p>
  
  <pre><code>&lt;?php $blobdata = $wpdb-&gt;get_results( "SELECT * FROM slips WHERE status = 'awaiting' " );
  
         foreach ( $blobdata as $bd ){
             $view = $bd-&gt;bet_options_ids; echo $view; 
          }
           endforeach;
          ?&gt;
  </code></pre>
  
  <p>The above code prints as: a:1:{i:5;s:4:"1.45";}</p>
  
  <p>Here I want to store the value of i:5 (i = 5) in variable say <strong>$store_i = $bd->bet_options_ids;</strong></p>
  
  <p>I have no idea how can I get that individual data to store in variable or even just print out individually.</p>
  
  <p>Anyone's suggestions will be really helpful.</p>