How to create a where query for Json in mysql with key having a white space in between the name

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.