只根据id在mysql php中出现一个表行

Question

I have a table that looks like this

id            |            itemID        |         catID     |      Title
----------------------------------------------------------------------------
0                           3                       4                Hello
1                           3                       6                Hello
2                           4                       4                Yo
3                           4                       8                Yo
4                           5                       2                Hi
5                           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

That didn't seem to work, it still just shows duplicates.

Answer 1

Is this what you are looking for? http://www.sqlfiddle.com/#!2/5ba87/1

select itemID, Title from test group by itemID;