MySQL 8 Cookbook

Retrieve JSON

You can retrieve the fields of the JSON column using the -> and ->> operators:

mysql> SELECT emp_no, details->'$.address.pin' pin FROM emp_details;+--------+----------+| emp_no | pin      |+--------+----------+| 1      | "560103" |+--------+----------+1 row in set (0.00 sec)

To retrieve data without quotes, use the ->> operator:

mysql> SELECT emp_no, details->>'$.address.pin' pin FROM emp_details;+--------+--------+| emp_no | pin    |+--------+--------+| 1      | 560103 |+--------+--------+1 row in set (0.00 sec)