[Wolves] Happy Christmas ...and help me with this mysql query

[Wayne Morris]

Hi,

Happy Xmas ;-)
Now pay for it with :

How do I select from
Item      Parts

Item A   Part1
Item A  Part2
--------    -------
ItemA   Part11
ItemA    Part 12
ItemB    Part1
ItemC    Part1
ItemD    Part 1
ItemD    Part 2

I want to select only the first part for each item, but if I do select 
Item where Parts like '%1%', I get Part1 and Part11 and Part 12, etc
cheers

Wayne