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

Wayne Morris waynelists at machx.co.uk
Thu Dec 27 16:43:58 UTC 2012


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


More information about the Wolves mailing list