mysql DELETE rows when multiple conditions are met

Question

So, I have following wpdb DELETE function:

$wpdb->delete( $table, array( 'sub_id' => $sub_id ) ????);

I want to delete rows where WHERE two conditions are met

For example, when sub_id = $sub_id AND date = $date, then I want to delete a row where these two conditions are available.

How do I change above function?

Thanks

Dan Ovidiu Boncut · Accepted Answer · 2016-01-31 02:32:21Z

1

You can go in this direction:

$wpdb->query("DELETE FROM table_name WHERE 'sub_id'=".$sub_id." AND date=".$date);

answered Jan 31, 2016 at 2:32

Dan Ovidiu Boncut

3,1754 gold badges29 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks for the reply. And yeah, I didn't find any info other this method. Thanks

aswiss · Accepted Answer · 2017-07-17 14:20:31Z

1

If you want to use multiple where conditions, than the second parameter should be a associative array. The conditions will be joined with "AND".

$wpdb->delete($wpdb->prefix . 'table_name', array('sub_id' => $sub_id, 'date' => $date));

Following query will be generated: DELETE FROM wp_table_name WHERE sub_id = 1 AND date = 2017-07-17 00:00:00

For more info look here: DELETE Rows

answered Jul 17, 2017 at 14:20

aswiss

351 silver badge11 bronze badges