title: MYSQL Case in select statement for checking null
body: <p>in MySQL query if I pass :</p>
  
  <pre><code>  case guides.Gud_Publish_Date 
       when null then "Unscheduled" 
       else "Forth Coming Titles" 
    end
  </code></pre>
  
  <p>then it is considering all is null even the Gud_Publish_Date has value also. the full SQL statement is </p>
  
  <pre><code>SELECT guides.Gud_Id
      , guides.Gud_Image
      , guides.Gud_SubEditor
      , guides.Gud_Reprint_Status
      , guides.Gud_Publish_Date
      , guides.Gud_Img_Chk
      , guides.Gud_Published
      , guides.Gud_View
      , (
          CASE guides.Gud_Publish_Date
              WHEN NULL
                  THEN "Unscheduled"
              ELSE "Forth Coming Titles"
              END
          ) AS Schedules
  FROM guides
  </code></pre>
  
  <p>Can anybody help me? Thanks in advance</p>