Is there a way to get a short text count over multiple columns?
For example: In a database for fruit sales, customers bought the following:
1. Apples
2. Apples & Grapes
3. Bananas, Grapes, and Apples
4. Grapes, Apples, and Strawberries
So in this example, Apples can appear in any one of three columns. I can do counts for each column column for individual fruits, such as Apples.
But is there a way to get a single count for Apples in all three columns?
And if so, can I repeat the process for the other types of fruit in the same query? Or would I need to do a separate query for each fruit?