Answers for "if in mysql query"

if mysql

SELECT IF(500<1000, "YES", "NO");

if inside select mysql

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

mysql if statement in where clause

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

if in MySQL

IF(condition, value_if_true, value_if_false)

if condition mysql

IF(condition, value_if_true, value_if_false)