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

2 votes99 views1 answer
When matched in sql server
SQL
0 vote108 views1 answer
Create column that already exists mysql
SQL
2 votes56 views1 answer
Mysql admin u root p password change password
SQL
2 votes108 views4 answers
Mysql get all tables row count
SQL
-1 vote103 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
1 vote94 views1 answer
Mysql select another database
SQL
1 vote52 views1 answer
File /etc/init.d/mysql not exists
SQL
12 votes98 views4 answers
Mysql get date difference in hours
SQL
0 vote109 views3 answers
Query string not ending with with vowels
SQL
-3 votes105 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL