if mysql condition code example

Example 1: mysql if else

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

Example 2: in condition in mysql

//Syntax
SELECT * FROM `tableName` WHERE `ColumnName` IN (Value1,Value1,Value1);

//Example:
SELECT * FROM `members` WHERE `membership_number` IN (1,2,3);