yes, it's possible just use the GROUP_CONCAT function ;o) p.s. you did not specify which database you're working with, so that function will work only if you're using the right one sorry, mate, couldn't help it ;o)