How can I use JSON_EXTRACT in MySQL and get a string without the quotes?

Question

If I have a simple SELECT statement like this:

SELECT JSON_EXTRACT('{"username":"Alexander"}', '$.username'); 

I would expect it to return Alexander , but instead it returns "Alexander". How can I get rid of the quotes? Why does this function even return the quotes too?

Answer 1

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