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 vote166 views1 answer
Difference between db.query and db.execute
SQL
1 vote143 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
0 vote155 views2 answers
How to create a table from another table in sql derby
SQL
0 vote144 views1 answer
Postgres call view
SQL
0 vote164 views2 answers
Select last 30 days sql
SQL
1 vote160 views1 answer
Mysql column start with string
SQL
0 vote180 views2 answers
How to type a blank discord messgae
SQL
0 vote156 views4 answers
How to drop all tables in sql
SQL
13 votes171 views1 answer
Sql join 3 tables on id
SQL
1 vote147 views1 answer
Spring postgresql reset auto increment to 0
SQL