Parsing JSON in mysql 5.5
<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>