Why is this SQL statement (SELECT * FROM items WHERE id=2) returning only the first instance?

Question

I have the following table:

items:
id |color| price
1   red   10
2   red   11
2   blue  11.5
3   green 9

id and color make up the key. i want to return all items with id=2.

I tried using this statement

SELECT * FROM items WHERE id=2

but the output is only

Array([id] => 2 [color] => red [price]=>11)

Why doesnt it return both of the items of id = 2 (the red and blue) as expected? How do I return all items with id=2??

Answer 1

This should not be possible because a primary key is unique so you should only have one item with the id of 2.