$wpdb->delete column values IN ARRAY()?

Question

I am wondering if this is possible?

$wpdb->delete(
    'table_name',
    array('id' => array(1, 2, 3)),
    array('%d')
);

So, in this situation, it should remove 3 rows at once, and call the database only 1 time. I have a lot of deletions that could be possible with my script and would rather it just perform the deletion once, instead of having to loop through all of the ids and do a $wpdb->delete on each one individually. Is this possible? Seems like it should be...

sorrow poetry · Accepted Answer · 2016-05-22 08:22:42Z

2

as i see if your method dont work you can replace it with this one :

$idList = array('1','2','3','4','5');
$idListString = implode(",",$idList);
$wpdb->query("DELETE FROM this_table WHERE id IN ($idListString)");

but let me know if it works thanks

answered May 22, 2016 at 8:22

sorrow poetry

4135 silver badges11 bronze badges

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

1 Comment

Solomon Closson Over a year ago

No it doesn't work. And yes, I'm aware of the alternatives. Thanks just the same.

Collectives™ on Stack Overflow

$wpdb->delete column values IN ARRAY()?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related