MYSQL - Multiple count in rows instead of columns
When I execute the sql query bellow:
SELECT (SELECT count(STATE) FROM `table` WHERE STATE='MI') as E1, (SELECT count(STATE) FROM `table` WHERE STATE='ID') as E2 FROM `table`
the result is something like this:
E1 E2
12 15
One next to the other.
How could I have the results one BELLOW the other ?!!
This is what I would like:
E1 12
E2 15
Any ideas?
Re: MYSQL - Multiple count in rows instead of columns
You are actually looking for Group By. A group By would give you result like this
State Count
MI 12
ID 15
Try this query
PHP Code:
Select STATE, Count(STATE) From TABLE Group By STATE