title: Sql query with column=null returns zero result set
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/3878954/why-does-column-null-return-no-rows">Why does column = NULL return no rows?</a>  </p>
  </blockquote>
  
  
  
  <p>I am trying to query a row  from mysql database where value of certain column is null, here is my query:</p>
  
  <pre><code>SELECT * FROM `mytable` WHERE mycolumn=null
  </code></pre>
  
  <p>Actually I am using Boolean column as a three way switch where 0,1 and null meant to be used for different results. </p>
  
  <p>Above query is returning a zero result set and if I remove <code>where mycolumn=null</code> thing, its returning right result with some rows having null value for the specified column. </p>