Answers for "mysql if then"

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

if in MySQL

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

if condition mysql

IF(condition, value_if_true, value_if_false)
Posted by: Guest on October-24-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language