Does MySQL If statement have multiple conditions?

You can use if statement in a stored procedure with multiple conditions with the help of AND or OR operator. The syntax is as follows -

DECLARE X int;
DECLARE Y int;
SET X = value1;
SET Y = value2;
IF ( (X < Y AND X > value1 AND Y >value2) OR X! = anyValueToCompare) THEN
   yourStatement;
ELSE
   yourStatement;
END IF

Now to understand the above syntax, let us create a stored procedure. The query to create the stored procedure is as follows -

mysql> create procedure SP_IFELSEDEMO()
   -> BEGIN
   -> DECLARE X int;
   -> DECLARE Y int;
   -> SET X=100;
   -> SET Y=400;
   -> IF ( (X < Y AND X > 99 AND Y >300) OR X! = 10 ) THEN
   ->    SELECT &#39;Logic is Correct&#39;;
   -> ELSE
   ->    SELECT &#39;Logic is not Correct&#39;;
   -> END IF;
   -> END;
   -> //
Query OK, 0 rows affected (0.27 sec)
mysql> DELIMITER ;

Now call the stored procedure with the help of CALL command. The query is as follows -

mysql> call SP_IF ELSEDEMO();

Output

+------------------+
| Logic is Correct |
+------------------+
| Logic is Correct |
+------------------+
1 row in set (0.04 sec)
Query OK, 0 rows affected (0.07 sec)

The above is the detailed content of Does MySQL If statement have multiple conditions?. For more information, please follow other related articles on the PHP Chinese website!