title: Query capturing timestamp 0000-00-00 00:00:00
body: <p>How do I get this query to not pick up timestamps with the default DatePercentUpdate = 0000-00-00 00:00:00? I thought I had it by using 0, but it captures the 0000-00-00 00:00:00's.</p>
  
  <pre><code>$stmtSummary = $mysqliSummary
      -&gt;prepare("SELECT n.nodeID, n.percentRedYellow, n.count, c.Loopback_ip, c.city 
                 FROM CATV.CableData  c 
                 INNER JOIN CATV.node n ON n.nodeID = c.Node_ID   
                 INNER JOIN CATV.CM cm ON cm.LoopbackIP=c.Loopback_ip
                 WHERE c.LocationID IS NOT NULL 
                   AND c.Status_Update_Time &lt;= NOW() 
                   AND c.Status_Update_Time &gt;=(NOW() - INTERVAL 2 DAY) 
                   AND c.Status_Update_Time&gt;0
                   AND n.DatePercentUpdate &lt;= NOW() 
                   AND n.DatePercentUpdate &gt;=(NOW() - INTERVAL 2 DAY) 
                   AND n.DatePercentUpdate&gt;0
                   AND length(c.Node_ID)&gt;0
                 Group BY c.city, n.nodeID");
  </code></pre>
  
  <p>Added: I tried searching online to use 0000-00-00 00:00:00 in the query, but didn't find anything with that in a filter.</p>