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 vote128 views1 answer
Sql datum formatieren
SQL
0 vote127 views1 answer
Sql commands in android
SQL
7 votes114 views2 answers
Oracle foreign key reference table
SQL
0 vote110 views1 answer
How to select an index in oracle sql
SQL
5 votes126 views2 answers
Oracle rename table
SQL
3 votes129 views2 answers
Sqlite show table structure
SQL
2 votes123 views4 answers
ModuleNotFoundError: No module named 'mysql'
SQL
2 votes121 views1 answer
Mysql sysdate - 1 day
SQL
2 votes76 views1 answer
Sql view column data type
SQL
-2 votes130 views2 answers
Add auto_increment column to existing table mysql
SQL