get json extract value double quotes remove mysql code example

Example 1: mysql json_extract remove quotes

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

Example 2: mysql remove quote on json extract

JSON_UNQUOTE() – Remove Quotes from a JSON Document in MySQL