By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | data |
|---|---|
| 1 | {"ids": [1696]} |
| 2 | {"ids": ["1696"]} |
| id | data | JSON_SEARCH(data, 'all', 1696) |
|---|---|---|
| 1 | {"ids": [1696]} | null |
| 2 | {"ids": ["1696"]} | "$.ids[0]" |
| id | data |
|---|---|
| 1 | {"ids": [1696]} |
| 2 | {"ids": ["1696"]} |
| id | data | JSON_SEARCH(data, 'all', 1696) |
|---|---|---|
| 1 | {"ids": [1696]} | null |
| 2 | {"ids": ["1696"]} | "$.ids[0]" |