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 vote147 views1 answer
How to use a trigger to validate input data
SQL
0 vote155 views1 answer
Sql server order by nulls last
SQL
0 vote172 views1 answer
Compare if is null sql
SQL
49 votes262 views6 answers
Install mysql ubuntu
SQL
1 vote154 views1 answer
$query = mysqli_query($con, $sql); while ($row = mysqli_fetch_array($query))
SQL
0 vote158 views1 answer
Selects all the columns from the sailors table
SQL
11 votes163 views4 answers
Update row in mysql
SQL
0 vote151 views1 answer
10000000000000000000 am to meters
SQL
2 votes151 views1 answer
Add 2 hours to current time in MySQL
SQL
1 vote209 views1 answer
Ora-01950 no privileges on tablespace
SQL