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...
No, wpdb::delete does not handle anything other than WHERE field = X. You can just use the query method instead:
$ids = implode( ',', array_map( 'absint', $ids ) );
$wpdb->query( "DELETE FROM table_name WHERE ID IN($ids)" );
absint since that would only be relevant for UNSIGNED columns, and might not be the case. But thanks for your alternate method example just the same.
absint I suppose. Thanks anyways.
intval instead