title: How to extract data from Mysql column stored in serialized JSON column?
body: <p>I have column in mysql DB which contains serialized data (used PHP JSON encode to serialize them).</p>
  
  <p>Here is an example:  </p>
  
  <p>{"name":"Group ltd","email":"support@domain.org","auth":"Andrey Ucholnik"}</p>
  
  <p>Is there a built in function in mysql to extract these values without PHP ?
  I mean to build query that will unserialize data.</p>
  
  <p>Of course its possible to use combination of LOCATE and SUBSTR function to do that but I prefer something built in if possible.</p>