SELECT
`SK`.`id`,`SK`.`pCode`,`SK`.`pRCode`,`SP`.`pName`,`SK`.`pSugPrice`,`SK`.`stock`,`SK`.`pSpec`,`SK`.`pUnit`,`SP`.`pName`
FROM `product_sku` AS `SK` LEFT JOIN `product_spu` AS `SP` ON `SK`.`pId` = `SP`.`id` WHERE 1 AND
find_in_set('084501318314',SK.pRCode) AND SK.storeId='35' AND SK.isDel='0'
find_in_set参数必须加引号否则可能会报错
最新推荐文章于 2023-04-17 13:03:32 发布