SELECT
serve_cate_id
FROM
`base_manager_info` `info`
WHERE
JSON_CONTAINS(info.serve_cate_id, JSON_ARRAY( '1','2'))
考虑代码中包含的值可能是动态的,做以下处理:
$fwIds = [1,2];
$serveCateIds = join(",",$fwIds);
$serveCateIdsStr = "'".str_replace(",","','",$serveCateIds)."'";
SELECT
serve_cate_id
FROM
`base_manager_info` `info`
WHERE
JSON_CONTAINS(info.serve_cate_id,JSON_ARRAY( “.serveCateIdsStr.”))