ifnull

[rashmi_k28]

Here I will get the output as empty set.

How can I make to get value as -1 when there is empty set if status=1.

Please help me with this

 

 

select * from updowntime where status=1 and date(timestamp)=date(now()) and timestamp > '2008-03-24 11:10:01' and name='aaa';

[fenway]

get what value? if what is null?

[rashmi_k28]

If there is no timestamp which is greater with status=1

[aschk]

Basically i think he's asking how do you get "-1" when NO rows are being returned. Use your application, not the SQL. Unless you want to put it into a function, but then again if you put it into a function you can't return rows from a SQL statement, which is I would imagine what you're intending to do.

 

In summary: NO you can't because no rows are being returned. Use your application to determine this, or use SQL_CALC_ROWS, of couse this requires integrating it with your query/procedure as a separate step.