How to remove string quotes in MySQL 5.7 for function JSON_EXTRACT?
If you have MySQL 5.7.13 or later, you may use JSON_UNQUOTE() instead of JSON_EXTRACT() or -&gt;&gt; instead of -&gt;. Example:

SELECT field-&gt;&gt;"$.foo.barr" FROM table;