Multiple condition in a single IF in select query
SELECT IF(utc_timestamp >= DATE_ADD( initial_time, INTERVAL length_in_duration MINUTE)
AND date(utc_开发者_运维百科timestamp) < (closing_date)), 1 ,0) FROM table;
I get MySQL syntax error, any one please help.
There is a extra )
after closing_date))
I highly suggest you using a editor like Notepad++, where you can highlight parentheses/brackets and it will find the matching close/open ones.
精彩评论