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

5 votes202 views1 answer
Ignore duplicate rows in sqlite
SQL
11 votes209 views3 answers
Python sqlite3 create table if not exists
SQL
7 votes220 views1 answer
Query postgres delete duplicates
SQL
0 vote211 views7 answers
10 random questions use python and SQL
SQL
0 vote182 views2 answers
Postgresql create role
SQL
0 vote276 views1 answer
Sql select merge multiple values
SQL
0 vote207 views1 answer
How to add timestamp column in mysql
SQL
0 vote200 views1 answer
Execute sql stored procedure in powershell
SQL
2 votes228 views3 answers
Sql server: how to concatenate column data using comma
SQL
1 vote224 views1 answer
Oracle compile schema
SQL