If my row has a
As you said, you're using MySQL 5.6, so the
JSON_EXTRACT() function is not available.
The only options I would recommend are:
Upgrade to MySQL 5.7
Fetch the whole JSON document into an application and use a JSON decoding function.
You could also try to parse JSON using other string functions available in MySQL 5.6, but it'll be awkward and time-consuming to develop.