Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

mysql if statement in where clause

SELECT  `id` ,  `naam` 
FROM  `klanten` 
WHERE IF(`email` != '', `email`, `email2`) LIKE  '%@domain.nl%'
Source by www.mysqltutorial.org #
 
PREVIOUS NEXT
Tagged: #mysql #statement #clause
ADD COMMENT
Topic
Name
2+3 =