我需要更新pm_virtual.meta_value = 'no'
的值,只为那些有pm_downloadable.meta_value = 'yes'
的产品.我该怎么做呢?
SELECT
p.ID,
p.post_title,
pm_downloadable.meta_value AS downloadable_trait,
pm_virtual.meta_value AS virtual_trait
FROM
xhdps_posts AS p
INNER JOIN xhdps_postmeta AS pm_downloadable ON p.ID = pm_downloadable.post_id
LEFT JOIN xhdps_postmeta AS pm_virtual ON p.ID = pm_virtual.post_id
AND pm_virtual.meta_key = '_virtual'
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_value = 'no'