发布于 2021-08-22 15:46:41
Bug #79233: JSON_SEARCH does not search for non-string values
如果您的JSON标量值是字符串,您可以找到它们:
mysql> SELECT JSON_SEARCH('[12, 13, {"12": "123"}]', 'one', '123', null, '$[*]') path;
^^^^^ quoted string value
+---------------+
| path |
+---------------+
| "$[2].\"12\"" |
+---------------+https://stackoverflow.com/questions/68882785
复制相似问题