How to get rid of quotes when concat and json_extract?

Question

SQL

The request is the following:

SELECT concat(
    json_extract(additional,'$.surname'),
    json_extract(additional,'$.firsname'),
    json_extract(additional,'$.lastname')
)
FROM `user_attributes`

But in the end, the result is displayed in the following syntax:
"Петров""Петр""Петрович"

Please tell me, is it possible to remove quotes from the result?

Answer 1

JSON_UNQUOTE

SELECT concat(
    JSON_UNQUOTE(json_extract(additional,'$.surname')),
    JSON_UNQUOTE(json_extract(additional,'$.firsname')),
    JSON_UNQUOTE(json_extract(additional,'$.lastname'))
) fullname
FROM `user_attributes`
;

MySQL JSON_UNQUOTE