title: Parsing JSON in mysql 5.5
body: <p>I have a string stored as json in a mysql table. I need to parse the string and return the value within a stored procedure. </p>
  
  <p>Does Mysql 5.5 support this? </p>
  
  <p>I came across this UDF: <a href="https://github.com/ChrisCinelli/mysql_json" rel="noreferrer">https://github.com/ChrisCinelli/mysql_json</a></p>
  
  <p>Unfortunately, I cannot install this UDF on my mysql server due to operational issues.</p>
  
  <p>How to parse json in mysql?</p>
  
  <p><strong>Note:</strong> We use percona version of MySQL</p>