SQL match cols by JSON on other table

✔ Recommended Answer

we can try to use json_contains function to filter JSON value with subquery.

select *from members mwhere exists (    select 1    from clubhouse c    where json_contains(c.members, concat('"', m.id, '"'))    AND c.id = 55)


Source: stackoverflow.com

Answered By: D-Shih


Most Popular

PhpStorm, return value is expected to be 'A', 'object' returned

Remove Unicode Zero Width Space PHP

Laravel file upload returns forbidden 403, file permission is 700 not 755