批量下架OC产品

UPDATE oc_product p
JOIN oc_product_description pd ON p.product_id = pd.product_id
SET p.status = 0
WHERE pd.name LIKE ‘%24%’ OR pd.name LIKE ‘%23%’;