实现类似下图这种多选的筛选
类似SQL:
SELECT id as cargoods_id,`name`,`image`,`price` FROM `fa_cargoods` WHERE `status` = 'normal' AND `carcountry_id` IN (1,2) AND `carspeed_id` IN (1,2) AND `carhbbz_id` IN (1,2) AND `carstructure_id` IN (1,2) AND `caroutvol_id` IN (1,2) AND `carfuel_id` IN (1,2) AND `carseat_id` IN (1,2,3) AND `cardrive_id` IN (1,2) AND ( `carsafeconfig_id` LIKE '%1%' or `carsafeconfig_id` LIKE '%2%' or `carsafeconfig_id` LIKE '%3%' ) AND ( `carcomfortconfig_id` LIKE '%1%' or `carcomfortconfig_id` LIKE '%2%' or `carcomfortconfig_id` LIKE '%3%' ) ORDER BY `id` DESC LIMIT 0,10
代码如下:
记录一下,欢迎大佬留言更好的实现方式