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.