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 vote159 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
12 votes142 views1 answer
How to change the value of a table in sql
SQL
0 vote146 views1 answer
Ksql quickstart docker
SQL
-1 vote153 views5 answers
Convert sql to linq query online
SQL
57 votes325 views5 answers
How to create a new user in postgresql
SQL
5 votes174 views2 answers
Add days in oracle sql
SQL
0 vote149 views1 answer
How to set up an anonymous function to variable in swift
SQL
3 votes149 views1 answer
Insert into table from another table mysql
SQL
2 votes126 views1 answer
How to delete columns in sql
SQL
0 vote137 views1 answer
Mysql_error replacement
SQL