MySQL 5.7.8+ supports native JSON type. While you have different ways to create json objects, you can access and read members in different ways, too.
Main function is
->> operators are more friendly.
|json_doc||valid JSON document|
Mentioned in MySQL 5.7 Reference Manual
If it is possible that those arguments could return multiple values, the matched values are autowrapped as an array, in the order corresponding to the paths that produced them. Otherwise, the return value is the single matched value.
Returns NULL if any argument is NULL or no paths locate a value in the document.