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

0 vote274 views1 answer
Less than date query sqlachemy
SQL
0 vote239 views1 answer
Mysql earlier than date
SQL
23 votes281 views6 answers
Create table sql server
SQL
0 vote276 views1 answer
Laravel migration sql dump
SQL
0 vote286 views1 answer
How to convert external table to managed table in hive
SQL
23 votes266 views4 answers
How to uninstall postgresql in ubuntu
SQL
0 vote256 views1 answer
Kotlin sqlite delete row
SQL
0 vote258 views1 answer
How to check default value of column in sql server
SQL
0 vote267 views1 answer
How to close external sql connection in laravel
SQL
1 vote270 views1 answer
Mysql current running queries
SQL