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

8 votes325 views1 answer
Mysql restore database
SQL
0 vote342 views1 answer
Sql server get date of previous sunday
SQL
0 vote361 views1 answer
Sql quary intervewi question
SQL
2 votes341 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 11:04:35 PM [mysql] This may be due to a blocked port, missing dependencies,
SQL
3 votes333 views2 answers
WhereIn SQL
SQL
1 vote346 views1 answer
Continue in sql
SQL
1 vote365 views1 answer
Key validation sql
SQL
2 votes366 views1 answer
Dbms transaction (psql)
SQL
2 votes356 views3 answers
Sql server: how to concatenate column data using comma
SQL
-1 vote405 views1 answer
How to Activate the database
SQL