MySQL IFNULL question

mysql ifnull
Dan picture Dan · Jan 27, 2010 · Viewed 16.2k times · Source

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.

Answer

Jan Hančič picture Jan Hančič · Jan 27, 2010 
IFNULL((SELECT 'Yes' FROM mytable WHERE id = 1), 'No')

Related questions

MySQL IFNULL ELSE

I have a select statement where I want to make the select conditional like this: IFNULL(field_a, field_a, field_b) so that it checks field a. If a is null then the select would be field b. Is …

Read More
In MySQL, which is more efficient: IFNULL or NULLIF?

These two MySQL functions do the same thing: IFNULL(column_name, 'test') = 'test' or NULLIF(column_name, 'test') IS NULL Which one is more efficient?

Read More
How does MySQL CONCAT IFNULL work with more than two values?

I need to CONCAT two fields, if they both exist and add parentheses around the second field. Otherwise I just need to list the first field. Here's the simple version: SELECT id, CONCAT(name,' (',nickname,')') as …

Read More