I am using the mysql in my job.
so, I used function "COALESCE" recently. It's very useful, see the following code.
SELECT
id,
name,
COALESCE(phone, 'Not set') AS phone
FROM users;
Appear "Not set' by default value.
We can use "COALESCE" instead of "IFNULL".