IF in mysql query code example

Example 1: if inside select mysql

SELECT IF(1>3,'true','false');

Example 2: mysql if statement in where clause

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