delete rows where id is in a comma delimited string

Question

I need to delete all rows where id is in a comma delimited string.

$ids = '1,2,3,4,5'; 
$sql = "delete from images where id in(:aid)";
$st = $db->prepare($sql);
$st->execute([
    ":aid" => $ids
]);

Result - only one row is deleted.

If you use [FIND_IN_SET()](http://www.mysqltutorial.org/mysql-find_in_set) then you can treat your comma delimited string as a string. — KIKO Software, Nov 18 '19 at 07:36
If you want to use `find_in_set`, here's an example https://stackoverflow.com/questions/48560910/mysql-delete-where-not-in-find-in-set — nice_dev, Nov 18 '19 at 07:41

Anant Kumar Singh · Accepted Answer · 2019-11-18T08:15:35.717

0

$st->execute([
    ":aid" => "'".implode("','", explode(",",$ids))."'"
]);

$sql = "Delete from images WHERE FIND_IN_SET(`id`, :aid)";
$st = $db->prepare($sql);
$st->execute([
   ":aid" => $ids
]);

edited Nov 18 '19 at 08:15

answered Nov 18 '19 at 07:36

Anant Kumar Singh

1 Answers1