How to remove string quotes in MySQL 5.7 for function JSON_EXTRACT? Other than doing string manipulation after each JSON_EXTRACT, is there a simpler or more correct way to have the JSON_EXTRACT return the string WITHOUT the enclosing quotes?
Or should this question be on StachExchange?
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;