mysql解析json小技巧

有时间多看看官网：https://dev.mysql.com/doc/refman/5.7/en/json-function-reference.html
where 解析json字段 in (1,3);
官方实例：（参考最后一种方式）
mysql> SELECT * FROM jemp WHERE g > 2;
±------------------------------±-----+
| c | g |
±------------------------------±-----+
| {“id”: “3”, “name”: “Barney”} | 3 |
| {“id”: “4”, “name”: “Betty”} | 4 |
±------------------------------±-----+
2 rows in set (0.01 sec)

mysql> SELECT c->’$.name’ AS name
-> FROM jemp WHERE g > 2;
±---------+
| name |
±---------+
| “Barney” |
| “Betty” |
±---------+
2 rows in set (0.00 sec)

mysql> SELECT JSON_UNQUOTE(c->’$.name’) AS name
-> FROM jemp WHERE g > 2;
±-------+
| name |
±-------+
| Barney |
| Betty |
±-------+
2 rows in set (0.00 sec)

mysql> SELECT c->>’$.name’ AS name
-> FROM jemp WHERE g > 2;
±-------+
| name |
±-------+
| Barney |
| Betty |
±-------+
2 rows in set (0.00 sec)