CODE EXAMPLE FOR JAVASCRIPT

mysql json_extract remove quotes

select JSON_UNQUOTE(JSON_EXTRACT(base, '$.scope')) as scope from t_name