How to convert this sql query to active record query in rails? Need a solution for mysql database
SELECT *
FROM users
CROSS JOIN JSON_TABLE(campaigns_list, ‘$[*]’ COLUMNS (
campaign_name varchar(100) PATH ‘$.campaign_name’,
campaign_id varchar(100) PATH ‘$.campaign_id’
)
) AS j
WHERE campaign_name IN(‘cam4′,’cam1’);