|
Compare:
|
MariaDB 10.2
|
MariaDB [test]> SET @j = '["abc", [{"k": "10"}, "def"], {"x":"abc"}, {"y":"bcd"}]';
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [test]> SELECT JSON_SEARCH(@j, 'all', '10', NULL, '$**.k');
|
+---------------------------------------------+
|
| JSON_SEARCH(@j, 'all', '10', NULL, '$**.k') |
|
+---------------------------------------------+
|
| NULL |
|
+---------------------------------------------+
|
1 row in set (0.00 sec)
|
|
MySQL 5.7
|
MySQL [test]> SET @j = '["abc", [{"k": "10"}, "def"], {"x":"abc"}, {"y":"bcd"}]';
|
Query OK, 0 rows affected (0.00 sec)
|
|
MySQL [test]> SELECT JSON_SEARCH(@j, 'all', '10', NULL, '$**.k');
|
+---------------------------------------------+
|
| JSON_SEARCH(@j, 'all', '10', NULL, '$**.k') |
|
+---------------------------------------------+
|
| "$[1][0].k" |
|
+---------------------------------------------+
|
1 row in set (0.00 sec)
|
|