mysql - 抓取多行 MYSQL 连接

Question

这适用于 WordPress/Woocommerce

我正在使用此查询来获取特定的 meta_value based 匹配 wp_postmeta 和 wp_posts 中的 post_ids/p>

SELECT meta.meta_value
FROM wp_postmeta AS meta
JOIN wp_posts AS o
ON meta.post_id = o.ID
WHERE o.post_type = 'shop_order' AND o.post_status='wc-cancelled' AND meta.meta_key='_billing_email' 
ORDER BY o.post_date DESC

我的问题是我还想在同一查询中针对相同条件获取 meta.meta_keys = '_billing_first_name' 和 '_billing_last_name'。现在我必须分别获取每一行，然后将它们组合到 Excel 工作表中。

有办法吗？

Answer 1

如果我理解正确，一个简单的 OR 或使用 IN 就可以了

SELECT meta.meta_value
FROM wp_postmeta AS meta
JOIN wp_posts AS o
ON meta.post_id = o.ID
WHERE o.post_type = 'shop_order' AND o.post_status='wc-cancelled'
  AND meta.meta_key IN ('_billing_email' , '_billing_first_name', '_billing_last_name')
ORDER BY o.post_date DESC