SELECT location_code,position_type FROM
(SELECT
CASE WHEN location_code IS NULL THEN 0 ELSE 1 END location_code,
CASE WHEN position_type IS NULL THEN 0 ELSE 1 END position_type
FROM `ks_container` WHERE position_type='common_shelf' AND container_code IN
(SELECT `container_code` FROM `ks_sub_container` WHERE id IN (SELECT ks_sub_container_id FROM ks_stock WHERE sku_code IN ('pandian_sku_1sub')))) t
WHERE FIND_IN_SET(1,location_code) AND FIND_IN_SET(1,position_type)
记录一次sql查询方法,判断值是否存在FIND_IN_SET
于 2022-08-31 16:23:28 首次发布