Dear all,
I have a table Kids which has the following fields:
kid char(20),
favorite_fruits set('apple','pear','orange',....)
favorite_fruits has choices of up to 64 items.
Now I want to query the count of each fruit appears in the favorite_fruits of the kids
in the table. Is there anyway to use 'group by' to get the count, such as: select
count(*) from Kids group by favorite_fruits?
But if use above statement, the results will group by 'apple', 'apple, pear', 'apple,
pear, orange' instead of by 'apple', 'pear', 'orange'
Or I have to do one by one such as:
select count(*) from Kids where favourite_fruits like '%apple%'
and loop against the items in the set?
Any help will be appreciated!
Thanks!
Anya
http:www.acmescripts.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
