By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| version() |
|---|
| 5.7.39 |
Records: 2 Duplicates: 0 Warnings: 0
Records: 3 Duplicates: 0 Warnings: 0
| id | references |
|---|---|
| 1 | 225b312c335d22 |
| 2 | 225b322c335d22 |
| id | name |
|---|---|
| 1 | item_1 |
| 2 | item_2 |
| 2 | item_3 |
| references |
|---|
| 225b312c335d22 |
| JSON_SEARCH((select `references` from table_a where id=1), 'one', '3') |
|---|
| null |