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 that...

How is the IFNULL of SQL implemented in Symfony2 Doctrine Query Builder? Let's say I have this query: select * from ticket order by IFNULL(modified_date, '2000-01-01') DESC, created_date DESC I ...

What is the equivalent of SQLite's IFNULL() in Postgres? I have to following query (sqlite in Ruby): SELECT ifnull(max(code_id) + 1, 1) FROM configentries WHERE configtable_id = ... How shoul...

I have tried to use IFNULL to replace the NULL fields returned by ROLLUP for subtotals and totals but it doesn't appear to be working. Query: select IFNULL(usergroups.name, 'GROUP') AS DEALER, IFNU...

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?

Ok i have this code: SELECT IFNULL(s2.id,s1.id) AS effectiveID, IFNULL(s2.status, s1.status) AS effectiveStatus, IFNULL(s2.user_id, s1.user_id) as effectiveUser, IFNULL(s2.likes_count, s1.likes...

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 rath...

My statement should replace every empty title_column with 'no name', but it doesn't: SELECT COALESCE(main_table.title_column, 'no name') AS title FROM main_table; IFNULL() behaves the same way. Wh...

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,' (',...

I have a table in which a field contains an integer or NULL. parent_id 2 4 6 NULL NULL 45 2 How would I go about adding an IFNULL statement so that ans_count will be populated with 0 instead of ...