Wordpress databse insert() and update() - using NULL values
        Posted  
        
            by pygorex1
        on Stack Overflow
        
        See other posts from Stack Overflow
        
            or by pygorex1
        
        
        
        Published on 2010-04-08T01:18:33Z
        Indexed on 
            2010/04/08
            1:23 UTC
        
        
        Read the original article
        Hit count: 473
        
Wordpress ships with the wpdb class which handles CRUD operations. The two methods of this class that I'm interested in are the insert() (the C in CRUD) and update() (the U in CRUD).
A problem arises when I want to insert a NULL into a mysql database column - the wpdb class escapes PHP null variables to empty strings. How can I tell Wordpress to use an actual MySQL NULL instead of a MySQL string?
© Stack Overflow or respective owner