How to use a condition with "COUNT" in MySQL?

Question

I am getting error in this query,

SELECT count(if(state=0)) FROM `nagios`.`nagios_hostchecks`
where `nagios_hostchecks`.`start_time` like '%2012-01-02%'
and `nagios_hostchecks`.`host_object_id`=60;

Mind posting the error you received?

Kenaniah
– Kenaniah

2012-01-02 05:34:51 +00:00
Commented Jan 2, 2012 at 5:34 — Kenaniah
– Kenaniah, Commented Jan 2, 2012 at 5:34

John Woo · Accepted Answer · 2012-01-02 05:36:13Z

3

How about this:

SELECT count(*) 
FROM `nagios`.`nagios_hostchecks` 
WHERE `nagios_hostchecks`.`start_time` like '%2012-01-02%' 
    AND 
`nagios_hostchecks`.`host_object_id`=60
    AND
`state` = 0;

answered Jan 2, 2012 at 5:36

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Adrian Cornish · Accepted Answer · 2012-01-02 05:34:44Z

3

Just a quick guess without checking nagios schema

SELECT count(*) FROM nagios.nagios_hostchecks
WHERE state=0 AND nagios_hostchecks.start_time like '%2012-01-02%' 
AND nagios_hostchecks.host_object_id=60;

answered Jan 2, 2012 at 5:34

Adrian Cornish

24k14 gold badges64 silver badges81 bronze badges

Collectives™ on Stack Overflow

How to use a condition with "COUNT" in MySQL?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related