Title: insert null values using $wpdb->insert
Last modified: August 20, 2016

---

# insert null values using $wpdb->insert

 *  [niska](https://wordpress.org/support/users/niska/)
 * (@niska)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/insert-null-values-using-wpdb-insert/)
 * How do I use $wpdb->insert with null values? I have a variable that sometimes
   is null and sometimes contains text.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Anders](https://wordpress.org/support/users/seananders1227/)
 * (@seananders1227)
 * [14 years, 6 months ago](https://wordpress.org/support/topic/insert-null-values-using-wpdb-insert/#post-2441709)
 * has $wpdb->insert($wpdb->table, array(‘field’ => ‘NULL”)); not worked?
 *  [pruma](https://wordpress.org/support/users/pruma/)
 * (@pruma)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/insert-null-values-using-wpdb-insert/#post-2441790)
 * I guess that’s a know issue.
 * [http://core.trac.wordpress.org/ticket/15158](http://core.trac.wordpress.org/ticket/15158)
 * For me it works omitting all values with null (in data and format), setting it
   to the mysql default value.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘insert null values using $wpdb->insert’ is closed to new replies.

 * In: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/)
 * 2 replies
 * 3 participants
 * Last reply from: [pruma](https://wordpress.org/support/users/pruma/)
 * Last activity: [14 years, 4 months ago](https://wordpress.org/support/topic/insert-null-values-using-wpdb-insert/#post-2441790)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics