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)