Answers for "mysql if and statement"

mysql else if

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

Posted by: Guest on October-16-2020

mysql if else

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

Posted by: Guest on May-29-2020

mysql if statement in where clause

SELECT  `id` ,  `naam` 
FROM  `klanten` 
WHERE IF(`email` != '', `email`, `email2`) LIKE  '%@domain.nl%'

Posted by: Guest on April-15-2021

Code answers related to "mysql if and statement"