Answers for "mysql if statement"

SQL
7

mysql else if

IF condition1 THEN
    statements;
ELSEIF condition2 THEN # OPTIONAL
	statements;
ELSE # OPTIONAL
    statements;
END IF;
Posted by: Guest on October-16-2020
0

mysql if else

SELECT OrderID, Quantity, 
CASE WHEN Quantity > 10 THEN "MORE" ELSE "LESS" END as x
FROM OrderDetails;

SELECT OrderID, Quantity, 
IF (Quantity > 10, "MORE", "LESS") as x
FROM OrderDetails;
Posted by: Guest on October-18-2021
0

if mysql

SELECT IF(500<1000, "YES", "NO");
Posted by: Guest on September-11-2021
3

mysql if else

IF condition THEN
   statements;
ELSE
   else-statements;
END IF;
Posted by: Guest on May-29-2020
0

mysql if statement in where clause

SELECT  `id` ,  `naam` 
FROM  `klanten` 
WHERE IF(`email` != '', `email`, `email2`) LIKE  '%@domain.nl%'
Posted by: Guest on April-15-2021
0

if in MySQL

IF(condition, value_if_true, value_if_false)
Posted by: Guest on July-14-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language