"how can i use json_extract in mysql and get a string without the quotes?" Code Answer

4

you can use json_unquote to achieve this.

select json_unquote(json_extract(base, '$.scope')) as scope from t_name

ref: functions that modify json values

By AntonyW on May 15 2022

Answers related to “how can i use json_extract in mysql and get a string without the quotes?”

Only authorized users can answer the Search term. Please sign in first, or register a free account.