Query (all possibilities)

[aopen]

Table has column 'target' enum('category','location'). How to get all possibilities from the table
(pairs of ids)

table test (
id auto_increment (primary),
target enum('category','location');
)

[devinemke]

not sure i understand the question. do you simply want the number of rows with "category" and the number of rows with "location"? if so then do a simple COUNT() query.

[alimadzi]

Not sure what you mean by "pairs of ids". Could you elaborate?