There's a rather handy command in Oracle, PostgreSQL, SQLite, and MySQL (since version 3.23.3) called COALESCE(). Its purpose is rather simple: return the first non-NULL value (If you're used to older versions of MySQL, the IFNULL() is quite similar, if not as flexible). This comes in handy when you want to use fallback values in […]
Recent Comments