title: Difference between NULL and Blank Value in Mysql
body: <p>I have to check for a value of a particular Column named <code>RESULT</code> is blank or not.</p>
  
  <p>When I check  with <code>if RESULT IS NULL</code>, the query failed, but When I checked <code>RESULT=''</code>, it worked.</p>
  
  <p>What is difference between two.</p>
  
  <p>please explain.</p>
  
  <pre><code>"UPDATE RLS_TP_2012_03 a, RLS_TP_2012_03 b SET a.COMMENT=b.COMMENT where b.TCODE='T1199' and  a.GROUPNAME='xyz' and a.HLABNO=b.HLABNO and a.RESULT =''; ";   
  "UPDATE RLS_TP_2012_03 a, RLS_TP_2012_03 b SET a.COMMENT=b.COMMENT where b.TCODE='T1199' and  a.GROUPNAME='xyz' and a.HLABNO=b.HLABNO and a.RESULT is NULL; "
  </code></pre>