ind the number of rows containing 'America':
select count(*)
from mytable
where Category = 'America'
To get the number of rows containing 'Wines', just replace 'America' with
'Wines' in the query.
Rhino
----- Original Message -
From
Selon Micha Berdichevsky <[EMAIL PROTECTED]>:
> Hi.
> I have a table that store different items. For each items, I can attach
> up to 5 different textual categories.
> Those categories are free-text, and different columns can have the same
> values (example below).
> I am trying to select the coun
Hi.
I have a table that store different items. For each items, I can attach
up to 5 different textual categories.
Those categories are free-text, and different columns can have the same
values (example below).
I am trying to select the count of each of those categories, regardless
of it's positi
