mysql json extract string without quotes code example
Example: mysql json_extract remove quotes
select JSON_UNQUOTE(JSON_EXTRACT(base, '$.scope')) as scope from t_name
select JSON_UNQUOTE(JSON_EXTRACT(base, '$.scope')) as scope from t_name