title: WordPress $wpdb->update set float to null?
body: <p>Is there a way to set a column to <code>NULL</code> using <code>$wpdb-&gt;update();</code>?</p>
  
  <p>When I attempt to, WordPress attempts to typecast that column to a float, which converts <code>NULL</code> to <code>0</code>.</p>
  
  <p>I've checked the core code and inside of <code>$wpdb-&gt;update()</code>, the <code>$format</code> parameter is only expecting %s, %f, and %d. I went so far as to set <code>$wpdb-&gt;field_types['myCol']</code> to <code>'NULL'</code>, but both only serve to break <code>$wpdb-&gt;update()</code>'s query (interestingly enough, it shifts the values for each column over after the <code>NULL</code>).</p>
  
  <p>There is a related question here, but that answer only deals with <code>INSERT</code>, <strong>not</strong> <code>UPDATE</code>.</p>
  
  <p>From a data integrity standpoint, <code>NULL</code> is very important for this column, so I have to be able to set it as such when necessary.</p>