Answers for "if in MySQL"

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
2

if inside select mysql

SELECT IF(1>3,'true','false');
Posted by: Guest on April-30-2020
3

mysql if else

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

mysql if statement

-- PL/SQL
BEGIN
    IF my_val = 1 THEN [...]
    ELSE [...]
    END IF;
END;
-- In a query
SELECT CASE WHEN my_col = 1 THEN 'Ok' ELSE 'Ko' END AS my_result;
Posted by: Guest on July-04-2021
0

if mysql

SELECT IF(500<1000, "YES", "NO");
Posted by: Guest on September-11-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