title: query php serialized string blob
body: <p>I have a field which stores a serialized php string.  Internally in mysql this field is stored as a blob data type.</p>
  
  <p>Is it possible in pure mysql to query that field for a specific value?</p>
  
  <p>by query i mean that as part of the serialized string there may be a value inside such as "myval=1"; I would like to match this.</p>