MySQL IFNULL question
16,607
Solution 1
IFNULL((SELECT 'Yes' FROM mytable WHERE id = 1), 'No')
Solution 2
Little Advance example of IFNULL
:
Problem: How to get the home phone number if office phone number is not available ?
Solution:
SELECT IFNULL(office_phone_no,home_phone_no) as contact_number
FROM employee_table e
where e.username = 'sumoanand';
Author by
Dan
Updated on July 31, 2022Comments
-
Dan almost 2 years
I have a query which contains a subquery which is something like this
IFNULL((SELECT id FROM mytable WHERE id = 1), 'No')
It works OK, but I would like to return the string 'Yes' on success rather than the actual id of the row.
Is there any way to override the value it returns?
Thanks.