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 vote222 views1 answer
Give a column name to values generated from case statement in sql
SQL
2 votes236 views1 answer
Postgresql resolv duplicate value violates unique constraint
SQL
1 vote232 views1 answer
Create new table from old table with data
SQL
1 vote246 views1 answer
Oracle get current schema
SQL
0 vote223 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote212 views1 answer
Sql offfset
SQL
6 votes221 views1 answer
How to count number of rows in sql
SQL
-1 vote249 views3 answers
MySQL shutdown unexpectedly
SQL
0 vote239 views2 answers
Cambiar nombre tabla mysql
SQL
23 votes245 views3 answers
Sql where contains part of string
SQL