Parsing JSON in mysql 5.5

mysql json percona
ssk picture ssk · Mar 9, 2016 · Viewed 10.7k times · Source

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.

Does Mysql 5.5 support this?

I came across this UDF: https://github.com/ChrisCinelli/mysql_json

Unfortunately, I cannot install this UDF on my mysql server due to operational issues.

How to parse json in mysql?

Note: We use percona version of MySQL

Answer

ssk picture ssk · Mar 9, 2016

I ended up using common_schema: https://storage.googleapis.com/google-code-archive-downloads/v2/code.google.com/common-schema/common_schema-2.2.sql

It has json parsing function: https://common-schema.googlecode.com/svn/trunk/common_schema/doc/html/extract_json_value.html

Related questions

JSON encode MySQL results

How do I use the json_encode() function with MySQL query results? Do I need to iterate through the rows or can I just apply it to the entire results object?

Read More
Can JavaScript connect with MySQL?

Can JavaScript connect with MySQL? If so, how?

Read More
How to test if a string is JSON or not?

I have a simple AJAX call, and the server will return either a JSON string with useful data or an error message string produced by the PHP function mysql_error(). How can I test whether this data is a JSON …

Read More