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 vote351 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
2 votes320 views1 answer
Latest record in sql
SQL
0 vote367 views4 answers
First max salary in sql
SQL
0 vote425 views1 answer
Selecting specific day in colum sql
SQL
0 vote362 views1 answer
Object of class mysqli_result could not be converted to string
SQL
0 vote394 views1 answer
.sql File Run in PSQL
SQL
1 vote360 views1 answer
Select not matching data with join table
SQL
0 vote338 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote382 views1 answer
Select milliseconds mysql
SQL
1 vote355 views1 answer
How to update date add hours in postgresql
SQL