Hi,

I'm in trouble in order to create a single query that returns the number of occurence for a value in 3 table fields ... I mean: if I can know I many time is matched a value in a single fields writing

mysql> SELECT count(field_1) FROM table WHERE field_1='value';

how can I continue in order to search and count on the others 2 fields using the same query?? I mean:

mysql> SELECT count(field_1),count(field_2),count(field_3) FROM table ... [how to continue??];

I've tryed a lot of solutions but anyone works .. :-(

Many thanks in advance max