calculating

[Anon]

hi i have serveral apples, strowberis, grapes, milk etc. in the field food

fid food
1 apple
2 milk
3 apple
4 orange
5 apple

now! how can i calculate how many apples do i have? thank you everyone. arman

[brandonschnell]

SELECT COUNT(food) FROM table WHERE food LIKE 'apple'