How to check empty or null in Mysql Query?
If you want to check empty or null value with conditional statement like case when and if in table row with Mysql database. you like to check empty or null value form table then you have multiple way check that. first we check empty value with case when statement then following example.
Empty Check:
SELECT
(CASE WHEN COALESCE(email,'')!='' THEN email ELSE '[email protected]' END) as test
FROM `customers`
---------------------OR----------------------
SELECT
(CASE COALESCE(email,'') WHEN '' THEN '[email protected]' ELSE email END) as test
FROM `customers`
---------------------OR----------------------
SELECT
(IF(COALESCE(email,'')!='',email,'[email protected]')) as exp
FROM `customers`
Null Check:
SELECT
(CASE WHEN email IS NULL THEN '[email protected]' ELSE email END) as test
FROM `customers`
---------------------OR----------------------
SELECT
(IF(email IS NULL,'[email protected]',email)) as exp
FROM `customers`
My name is Hardik Savani. I'm a full-stack developer, entrepreneur and owner of Aatman Infotech. I live in India and I love to write tutorials and tips that can help to other artisan. I am a big fan of PHP, Javascript, JQuery, Laravel, Codeigniter, VueJS, AngularJS and Bootstrap from the early stage.