title: Test for NULLs in multiple columns in MySQL
body: <p>I want to select columns from a table where the values of columns are NULL.</p>
  
  <p>For example:</p>
  
  <pre><code>SELECT * FROM table1 WHERE column1 IS NULL;
  </code></pre>
  
  <p>the above query returns rows where column1 doesn't have any value.</p>
  
  <p>But I want to return multiple columns(where column1,column2,....)</p>
  
  <p>I want to use this in MYSQL </p>