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 JSON_EXTRACT, hence -> and ->> operators are more friendly.
JSON_EXTRACT(json_doc,path[,...])
JSON_EXTRACT(json_doc,...