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 |