(MySQL) How to extract a json field with a dot inside (special character)

Question

First of all, I am using MySQL v5.7 .

Now, here is the problem... This following example works (provided by Official MySQL website) :

SELECT JSON_EXTRACT('{"id": 14, "name": "Aztalan"}', '$.name');

And it returns "Aztalan".

But this one doesn't work:

SELECT JSON_EXTRACT('{"user.id": 14, "user.name": "Aztalan"}', '$.user.name');

How can I get the "user.name" json property name with json_extract function?

Answer 1

Working way is to quote the key:

SELECT JSON_EXTRACT('{"user.name": "Aztalan"}', '$."user.name"');