mysql - 子查询在 WordPress 中返回多行

Question

我编写的代码部分，

(SELECT meta_value FROM wp_postmeta WHERE meta_key = '_regular_price') price

子查询返回多行时出错。如何获取价格？

SELECT p1.ID,p1.post_title,p1.post_excerpt,p2.meta_value, p1.guid,
(select p.guid from wp_posts as p where p2.meta_value=p.ID and post_type='attachment') img, (SELECT meta_value FROM wp_postmeta WHERE meta_key = '_regular_price') price
FROM wp_posts p1 
     JOIN wp_postmeta p2
     ON p1.ID = p2.post_id AND       
        p1.post_type = 'product' AND
        p1.post_status = 'publish' AND
         p2.meta_key = '_thumbnail_id' 
     JOIN wp_posts p3
     ON p3.ID = p2.post_id

Answer 1

在子查询中添加 CONCAT()，以用逗号分隔所有结果，然后对主查询使用 FIND_IN_SET。