Starting from MySQL 5.7.8, MySQL ships with a JSON type. Lots of devs have been saving JSON data in text columns for a log time but the JSON type is different, the data is saved in binary format after validation. That avoids the overhead of parsing the text on each read.
JOINS: Join 3 table with the same name of id.
CAST data to JSON type
This modified text is an extract of the original Stack Overflow Documentation created by following contributors
and released under CC BY-SA 3.0