mysql> SET @`json` :=
-> '[
'> {
'> "id": 1, "type": 2
'> },
'> {
'> "id": 2, "type": 1
'> }
'> ]';
Query OK, 0 rows affected (0.00 sec)
您可以在数组中获取所有ID:
mysql> SELECT JSON_EXTRACT(@`json` ,'$[*].id');
+----------------------------------+
| JSON_EXTRACT(@`json` ,'$[*].id') |
+----------------------------------+
| [1, 2] |
+----------------------------------+
1 row in set (0.00 sec)
可以访问每个JSON ID:
mysql> SELECT JSON_EXTRACT(@`json` ,'$[0].id');
+----------------------------------+
| JSON_EXTRACT(@`json` ,'$[0].id')