You can use ->> operator to extract unquoted data, simply!
SELECT JSONCOL->>’$.PATH’ FROM tableName Two other ways:
JSON_UNQUOTE(JSON_EXTRACT(column, path)) JSON_UNQUOTE(column->path) Note: Three different ways yield to the same command, as EXPLAIN explains:
As with ->, the ->> operator is always expanded in the output of EXPLAIN, as the following example demonstrates:
EXPLAIN SELECT c->>‘$.name’ AS name FROM jemp WHERE g > 2 ; SHOW WARNINGS ; *************************** 1. row *************************** Level: Note Code: 1003 Message: /* select#1 */ select json_unquote(json_extract(..,‘$.name’)) AS from . where (.. > 2) 1 row in set (0.00 sec)