• column ->> path 

This is an improved, unquoting extraction operator. Whereas the ->  operator simply extracts a value, the ->>  operator in addition unquotes the extracted result. In other words, given a JSON  column value column  and a path expression path  (a string literal), the following three expressions return the same value: 

• JSON_UNQUOTE( JSON_EXTRACT( column , path ) ) 

• JSON_UNQUOTE( column -> path ) 

• column ->> path 

The ->>  operator can be used wherever JSON_UNQUOTE(JSON_EXTRACT())  would be allowed. This includes (but is not limited to) SELECT  lists, WHERE  and HAVING  clauses, and ORDER BY  and GROUP BY clauses. 

The next few statements demonstrate some ->>  operator equivalences with other expressions in the mysql  client: 

mysql> SELECT * FROM jemp WHERE g > 2; +-------------------------------+------+ | c | g | +-------------------------------+------+ | {"id": "3", "name": "Barney"} | 3 | | {"id": "4", "name": "Betty"} | 4 | +-------------------------------+------+ 2 rows in set (0.01 sec) mysql> SELECT c->’$.name’ AS name -> FROM jemp WHERE g > 2; +----------+ | name | +----------+ | "Barney" | | "Betty" | +----------+ 2 rows in set (0.00 sec) mysql> SELECT JSON_UNQUOTE(c->’$.name’) AS name -> FROM jemp WHERE g > 2; +--------+ | name | +--------+ | Barney | | Betty | +--------+ 2 rows in set (0.00 sec) mysql> SELECT c->>’$.name’ AS name -> FROM jemp WHERE g > 2; +--------+ | name | +--------+ | Barney | | Betty | +--------+ 

