Episode-043 – Returning JSON Data as Relational Data in MySQL

This video demonstrates how to use the JOSN path operator in MySQL to extract data from a JSON object and return those values in a standard query result as if the values were stored in a separate column.

JSON – Path Operator Documentation – https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#operator_json-inline-path

JSON_EXTRACT() Documentation – https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#function_json-extract

JSON_UNQUOTE() Documentation – https://dev.mysql.com/doc/refman/8.0/en/json-modification-functions.html#function_json-unquote