mysql - count rows by field

Posted by Qiao on Stack Overflow See other posts from Stack Overflow or by Qiao
Published on 2010-03-24T23:48:14Z Indexed on 2010/03/24 23:53 UTC
Read the original article Hit count: 351

Filed under:

all rows in table have type field. It is either 0 or 1.

I need to count rows with 0 and with 1 in one query. So that result is something like:

type0 type1
1234 4211

How it can be implemented?

© Stack Overflow or respective owner

Related posts about mysql