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 vote123 views1 answer
Hw to delete a procedure in pl sql
SQL
0 vote124 views1 answer
Mysql case when null
SQL
10 votes133 views3 answers
Insert into auto increment mysql
SQL
0 vote121 views2 answers
Sql count number of rows after group by
SQL
37 votes128 views3 answers
Postgresql insert column
SQL
1 vote372 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote125 views1 answer
SQL loop with cursor
SQL
0 vote122 views1 answer
Oracle last character of string
SQL
5 votes153 views1 answer
Oracle generate list of dates in between a date range
SQL
0 vote126 views1 answer
Sql change primary key to composite key
SQL