php - 根据 id 在 mysql php 中仅获取表行的一次出现

Question

我有一个看起来像这样的表格

id            |            itemID        |         catID     |      Title----------------------------------------------------------------------------0                           3                       4                Hello1                           3                       6                Hello2                           4                       4                Yo3                           4                       8                Yo4                           5                       2                Hi5                           1                       3                What

I want to do a MySQL PHP Select that only gets one occurrence of the itemID. As you can see they are the same item, just in different categories.

This is what I tried

SELECT * FROM Table GROUP BY itemID

这似乎不起作用，它仍然只显示重复项。

Answer 1

这是您要找的吗？ http://www.sqlfiddle.com/#!2/5ba87/1

select itemID, Title from test group by itemID;