mysql - 联合查询后选择唯一的行

Question

有这个查询:

(select status, cb_ebook, product_id, titel, auther, image from oc_product where status and cb_ebook and titel like '%term%') 
UNION               
(select status, cb_ebook, product_id, titel, auther, image from oc_product where status and cb_ebook and auther like '%term%')

但是，结果中有重复的行，我只想要唯一的product_id - 我尝试按product_id分组，但这不起作用。

有什么解决办法吗？

Answer 1

您可以尝试在联合查询后添加不同的值，例如这样？

SELECT distinct(x.status) status,x.cb_ebook,x.product_id,x.titel,x.auther,x.image
FROM
(
(select status, cb_ebook, product_id, titel, auther, image from oc_product where status and cb_ebook and titel like '%term%')
UNION
(select status, cb_ebook, product_id, titel, auther, image from oc_product where status and cb_ebook and auther like '%term%')
) x