Recent content by ukmdg

I have a table with records with one field containing a comma separated string. for example within each field this may have something like Orange,Apple,Pear,Clementine,Melon I need a query to count the total orange or apple etc within the table. Is there an easy way of doing this? Thanks...