Answers for "mysql if statement in select"

if inside select mysql

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

Posted by: Guest on April-30-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 statement in select"