SELECT `col`->"$.name" FROM `json_users`;

SELECT * FROM `json_users` WHERE `col`->"$.options.x" = 100;