JSON_UNQUOTE(val)

Unquotes JSON value and returns the result as a utf8mb4 string. Returns
NULL if the argument is NULL. An error occurs if the value starts and
ends with double quotes but is not a valid JSON string literal.

URL: http://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html

