Paul J Stevens wrote: > Geo Carncross wrote: > > I wrote this query back in <[EMAIL PROTECTED]> > > > > I also suggested the alternative: > > > > select count(*), count(case when seen_flag > 0 Then 1 else null end), > > count(case when recent_flag > 0 then 1 else null end) FROM > > dbmail_messages WHERE status < '2' and mailbox_idnr='1'; > > and this one works for mysql-4.0 just fine.
It's also as efficient as the query I put up, so I'm cool with using it. I'll create a patch using it instead of what I proposed earlier. -- Kevin Brown [EMAIL PROTECTED]
