query question
From: cruiserweight <bayon86_at_yahoo.com>
Date: 8 Oct 2005 22:49:50 -0700
Message-ID: <1128836990.863752.213780_at_f14g2000cwb.googlegroups.com>
I'm using MySQL. I have a table that looks like this:
Date: 8 Oct 2005 22:49:50 -0700
Message-ID: <1128836990.863752.213780_at_f14g2000cwb.googlegroups.com>
I'm using MySQL. I have a table that looks like this:
+-----+---------------------+---------------------+ | cid | opened | closed | +-----+---------------------+---------------------+| 5 | 2005-10-12 11:55:22 | 0000-00-00 00:00:00 |
| 1 | 2005-10-09 10:12:30 | 2005-10-09 11:37:36 |
| 2 | 2005-10-10 11:12:45 | 0000-00-00 00:00:00 |
| 3 | 2005-10-10 12:33:15 | 0000-00-00 00:00:00 |
| 4 | 2005-10-11 10:36:16 | 0000-00-00 00:00:00 |
+-----+---------------------+---------------------+
What I want as a query result is the total number of rows in 'opened' and the total number of rows in closed that have a date assigned, i.e. opened=5, closed=1. I'm relatively new to MySQL, and I can't for the life of me get a handle on this one. Can this be done with a single
query? Do I need to make 'closed' a separate table?Thanks very much in advance for any and all suggestions. Received on Sun Oct 09 2005 - 07:49:50 CEST