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

-1 vote273 views1 answer
Mysql coalesce
SQL
0 vote323 views1 answer
Combine 2 columns search query mysql
SQL
3 votes321 views1 answer
Where id is in list sql
SQL
0 vote371 views1 answer
Mysql show schema
SQL
0 vote285 views1 answer
Openquery insert into linked server
SQL
1 vote295 views2 answers
Find nth highest salary of an employee
SQL
5 votes295 views3 answers
Bash: mysql: command not found
SQL
1 vote277 views1 answer
Import in mysql without a software
SQL
0 vote314 views1 answer
Mysql change default collation
SQL
0 vote298 views1 answer
Plpgsql raise notice
SQL