[RESOLVED] Help with Mysql statement

[fotofx]

I have a table called "raw_leads" that has a field called "list_id" I need to list how many of each list id there is.

Example:

1010
1010
1010
1111
1111
1000

I would want to return:

1010 3
1111 2
1000 1

I can do it with php by using an array but I am sure there is a mysql statement that would do the same thing quicker.

Thanks

[Lars_Berg]

select list_id,
       count(*) as entries
  from raw_leads
 group by list_id

[fotofx]

Thanks, I knew there had to be a way..

[fotofx]

One more question.. If there was an additional field, lets say "campaign" and wanted to do the above and then breakout the campaign field as a separate breakdown. How would I do that..

Example:

1010 campaigna
1010 campaignb
1010 campaignc
1111

Result:

1010 3 Total
1010 campaigna 1
1010 campaignb 1
1010 campaignc 1
1111 1 Total

[Lars_Berg]

select list_id,
       campaign,
       count(*) as entries
  from raw_leads
 group by list_id,
       campaign
  with rollup