Selecting two columns with diffrent WHERE clause

antubis · #1 (**permalink**) 02-27-06, 18:15

Hello,

I have to write an private message module, so I create this MySQL schema

id, uid ( who write the message ), subject, message, read ( is read or not ), date

So! I want to display how many are all the messages and how many are unread messages. Is there any way to do that with a single MySQL query?

Thank you!
Marush Denchev

r937 · #2 (**permalink**) 02-28-06, 00:12

Code:

select count(*) as all_messages
     , count(case when read='n' 
                  then 937 end) as unread_messages
  from daTable

Internet Services

Web Development

Digital Marketing

Consumer Tech