您可以使用UPDATE`` statement along with a JOIN`来根据指定的条件过滤产品。

UPDATE xhdps_postmeta AS pm_virtual
INNER JOIN xhdps_postmeta AS pm_downloadable ON pm_virtual.post_id = pm_downloadable.post_id
INNER JOIN xhdps_posts AS p ON pm_downloadable.post_id = p.ID
SET pm_virtual.meta_value = 'no'
WHERE 
    p.post_type = 'product'
    AND p.post_status = 'publish'
    AND pm_downloadable.meta_key = '_downloadable'
    AND pm_downloadable.meta_value = 'yes'
    AND pm_virtual.meta_key = '_virtual';

字符串

只需将查询中断，将XHDPS_POSTMETA表从SELECT查询中取出，并使用相关值UPDATE它，如下所示：

UPDATE XHDPS_POSTMETA
   SET
    META_VALUE = 'no'
WHERE meta_value != 'no'
  AND meta_key = '_virtual' 
  AND post_id IN (
SELECT p.ID
  FROM xhdps_posts AS p
  INNER JOIN xhdps_postmeta AS pm_downloadable ON p.ID = pm_downloadable.post_id
 WHERE     P.POST_TYPE = 'product'
       AND P.POST_STATUS = 'publish'
       AND PM_DOWNLOADABLE.META_KEY = '_downloadable'
       AND PM_DOWNLOADABLE.META_VALUE = 'yes');

字符串