how to remove double quotes from string while json_extract in mysql 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