How to pass NULL in where array for $wpdb->update

by

how to get results of a row with NULL element?
I have to update the row which contains only the post_id and the repeat value, ‘start’ and ‘end’ should be NULL

mysql table screenshot: http://i.imgur.com/l27is.png

$wpdb->update( $schedule_table, array( 'rpt' => $event_tag ), array( 'post_id' => $post_ID, 'start' => NULL, 'end' => NULL ), array( '%s' ) );
$wpdb->print_error();

I get this error:

WordPress database error: [] UPDATE wp_MW_3_schedule SET rpt = ‘monday’ WHERE post_id = 357 AND start = ” AND end = ”

3 Answers
3

My simple and quick solution is the use of a normal $wpdb->query() function:

$wpdb->query( $wpdb->prepare("UPDATE $schedule_table SET rpt = %s WHERE post_id = %d AND start IS NULL AND end IS NULL", $event_tag, $post_ID ) );

Leave a Comment