or problem

dimis2500 · #1 (**permalink**) 03-06-09, 10:57

I have this query

Code:

SELECT  *  FROM mytable
where( ( day=curdate() andtime<=curtime())
or
( day<curdate() and date_format( fltime,'%H:%i')<='24:00'))

I want this.

Code:

If where day=curdate() and 
time<=curtime()

has no values to go to the

Code:

or( day<curdate() and 
date_format( fltime,'%H:%i')<='24:00'))

But always get the values for

Code:

or( day<curdate() and 
date_format( fltime,'%H:%i')<='24:00'))

what is wrong?

r937 · #2 (**permalink**) 03-06-09, 11:55

you need to stop and re-think

an IF expression can have only three possible values -- TRUE, FALSE, or UNKNOWN

obviously you have some serious data issues there if you are having these problems of "going to" some other time column

Internet Services

Web Development

Digital Marketing

Consumer Tech