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 vote139 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote149 views1 answer
Mysql 8 error on identified by
SQL
1 vote146 views1 answer
Operator does not exist: integer = text
SQL
36 votes263 views6 answers
Change column data type sql
SQL
0 vote148 views1 answer
Get first 3 letter of department name in sql
SQL
1 vote168 views1 answer
Oracle select row max date
SQL
0 vote164 views1 answer
Codigo crear tablas sql server
SQL
1 vote173 views1 answer
Postgresql pass array in function
SQL
0 vote151 views1 answer
How to join result table in mysql
SQL
0 vote157 views1 answer
Gcloud sql list databases
SQL