MySQL IF without else

Mysql else if

IF condition1 THEN
    statements;
ELSEIF condition2 THEN # OPTIONAL
	statements;
ELSE # OPTIONAL
    statements;
END IF;

MySQL IF without else

SELECT * FROM callback LEFT JOIN agent ON callback.agent_ID=agent.agent_ID 
	LEFT JOIN contact ON callback.contact_ID=contact.contact_ID WHERE callback.agent_ID =118
	AND DATE(callback.cb_dt) =curdate() 
    and Hour(time(callback.cb_dt)) <= Hour(time(UTC_TIMESTAMP()))
    and 
	(if(Hour(time(callback.cb_dt)) = Hour(time(UTC_TIMESTAMP())),
     minute(time(callback.cb_dt)) < minute(time(UTC_TIMESTAMP())) and
    cb_IsDeleted=0 ,cb_IsDeleted=0))
	and callback.isCalled=0;

Similar codes

8 votes197 views3 answers
SQL column name
SQL
0 vote143 views1 answer
How do i calculate someone's age based on a datetime type birthday?
SQL
20 votes186 views4 answers
Sqlite create table if not exists
SQL
0 vote180 views1 answer
Power query case when
SQL
3 votes280 views3 answers
Restart mysql mac
SQL
0 vote227 views1 answer
Sql anywhere create procedure
SQL
1 vote247 views1 answer
Oracle grant select on schema
SQL
0 vote233 views1 answer
ERROR 1396 (HY000): Operation DROP USER failed for 'ananyapam'@'%'
SQL
0 vote193 views1 answer
Windows services sql
SQL
-1 vote192 views1 answer
How to dump .csv file into mysql
SQL