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 | +--------+ • JSON_UNQUOTE( column -> path ) • column ->> path • JSON_UNQUOTE( JSON_EXTRACT( column ,  path ) ) • column ->> path Functions That Search JSON Values 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: 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: 2352