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

2 votes145 views1 answer
Set boolean flasksql
SQL
2 votes147 views1 answer
Illuminate\Database\QueryException : SQLSTATE[HY000] [1698] Access denied for user 'root'@'localhost'
SQL
5 votes161 views1 answer
Get table columns from sql
SQL
0 vote146 views1 answer
Sql server express download
SQL
0 vote157 views1 answer
Sql query to find difference between total no. of rows and distinct rows in sql server
SQL
0 vote142 views1 answer
Sql server whoami
SQL
0 vote170 views1 answer
How to print sql query
SQL
1 vote168 views1 answer
Increase existing date in sql oracle
SQL
0 vote156 views1 answer
Sql server concat null
SQL
5 votes140 views2 answers
Sql number columns
SQL