Mysql if else

Mysql else if

IF condition1 THEN
    statements;
ELSEIF condition2 THEN # OPTIONAL
	statements;
ELSE # OPTIONAL
    statements;
END IF;

Mysql if else

IF condition THEN
   statements;
ELSE
   else-statements;
END IF;

Source: mysqltutorial.org

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;

Else if mysql

select id, 
    (SELECT 
    IF(qty_1<='23',price,1)
    ELSEIF(('23'>qty_1 && qty_2<='23'),price_2,1)
    ELSEIF(('23'>qty_2 && qty_3<='23'),price_3,1)
    ELSEIF('23'>qty_3,price_4,1)
    END IF) as total 
 from product;

Source: stackoverflow.com

Similar codes

0 vote321 views1 answer
Add new column in sql with foreign key
SQL
7 votes263 views2 answers
Create mysql user
SQL
0 vote275 views1 answer
Get who is hired in specific month in sql
SQL
1 vote297 views1 answer
Oracle drop job if exists
SQL
0 vote297 views1 answer
Get a list of tables and the primary key
SQL
0 vote281 views1 answer
Alter table fulltext
SQL
0 vote302 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
16 votes315 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
0 vote260 views1 answer
Mysql workbench search all tables
SQL
16 votes295 views1 answer
Sql comment'
SQL