title: What is the difference between IFNULL and COALESCE in MySQL?
body: <pre><code>SELECT IFNULL(NULL, 'Replaces the NULL')
  --&gt; Replaces the NULL
  
  SELECT COALESCE(NULL, NULL, 'Replaces the NULL')
  --&gt; Replaces the NULL
  </code></pre>
  <p>In both clauses the main difference is argument passing. For <code>IFNULL</code> it's two parameters and for <code>COALESCE</code> it's multiple parameters. So except that, do we have any other difference between these two?</p>
  <p>And how it differs in MS SQL?</p>