not in 查询in的相反的结果
SELECT *
from
j_product
where shopId=50
and itemNum not in (172664,172673,171865,173941)
and refreshDate >="2019-11-26"
not in 查询in的相反的结果
SELECT *
from
j_product
where shopId=50
and itemNum not in (172664,172673,171865,173941)
and refreshDate >="2019-11-26"