如何使用在名称之间有空格的键在mysql中为Json创建where查询

Question

With json as

{ "First Name": {"nickname" : "Abc"} }

in json column 'name' of mysql database.

How do I extract such rows in mysql.

Select * from users where name."$.First Name.nickname" = "abc";

won't work. Any solution because I cannot change the json structure in database.

Answer 1

Found the answer:

Select * from users where name."$.""First Name"".nickname" = "abc";

you need to double quote the key of JSON with a space.