I have two MySQL statements (see below), I would like to combine them together so if they both result in a 1 then the end result will be 1. I'm not sure how to construct this and was hoping for some help.
select count(*) from monitor where name='job_starttime' and value < ( UNIX_TIMESTAMP( ) -600) select count(*) from monitor where name='job_active' and value = 0
So for example I would like when both statements are true to result in a value of 1, if 1 or none are true it results in a 0.
I nearly achieved it with the below SQL (except it's giving a result for each entry in the table) :(
select case when (select count(*) from monitor where exists (select * from monitor where name = 'job1_active' AND value = 1) and exists (select * from monitor where name = 'job2_active' AND value = 1)) > 1 then 1 else 0 end from monitor