title: mysql equivalent expression to '0000-00-00 00:00:00'
body: <p>I would like to know if there any shorter expression exists, than this:</p>
  
  <pre><code>'0000-00-00 00:00:00'
  
  
  SELECT id FROM orders WHERE posted='0000-00-00 00:00:00' ORDER BY id DESC LIMIT 1;
  </code></pre>
  
  <p>I mean something like:</p>
  
  <pre><code>SELECT id FROM orders WHERE posted=null ORDER BY id DESC LIMIT 1;
  </code></pre>
  
  <p>I hope this is the schema you wanted to see:</p>
  
  <pre><code>array(19) {
    ["TABLE_CATALOG"]=&gt;
    NULL
    ["TABLE_SCHEMA"]=&gt;
    string(13) "teleprintfejl"
    ["TABLE_NAME"]=&gt;
    string(13) "megrendelesek"
    ["COLUMN_NAME"]=&gt;
    string(7) "posted"
    ["ORDINAL_POSITION"]=&gt;
    string(2) "20"
    ["COLUMN_DEFAULT"]=&gt;
    NULL
    ["IS_NULLABLE"]=&gt;
    string(2) "NO"
    ["DATA_TYPE"]=&gt;
    string(8) "datetime"
    ["CHARACTER_MAXIMUM_LENGTH"]=&gt;
    NULL
    ["CHARACTER_OCTET_LENGTH"]=&gt;
    NULL
    ["NUMERIC_PRECISION"]=&gt;
    NULL
    ["NUMERIC_SCALE"]=&gt;
    NULL
    ["CHARACTER_SET_NAME"]=&gt;
    NULL
    ["COLLATION_NAME"]=&gt;
    NULL
    ["COLUMN_TYPE"]=&gt;
    string(8) "datetime"
    ["COLUMN_KEY"]=&gt;
    string(0) ""
    ["EXTRA"]=&gt;
    string(0) ""
    ["PRIVILEGES"]=&gt;
    string(31) "select,insert,update,references"
    ["COLUMN_COMMENT"]=&gt;
    string(0) ""
  }
  </code></pre>