# Delete multiple entries using mysql?

**URL:** <https://forum.kirupa.com/t/delete-multiple-entries-using-mysql/22148>\
**Category:** Uncategorized\
**Created:** [May 30, 2003, 10:51pm UTC](https://forum.kirupa.com/t/delete-multiple-entries-using-mysql/22148 "2003-05-30T22:51:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sykes](https://avatars.discourse-cdn.com/v4/letter/s/96bed5/32.png) [@sykes](https://forum.kirupa.com/u/sykes)\
**Post date:** [May 30, 2003, 10:51pm UTC](https://forum.kirupa.com/t/delete-multiple-entries-using-mysql/22148/1 "2003-05-30T22:51:14Z")

</div>

how do i delete multiple entries from a table using mysql commands?

i tried doing: delete from table\_name where id = “11”, “12”, “13”;  
but obviously i was doing it wrong…

help mey peez :nerd:

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [June 1, 2003, 5:18am UTC](https://forum.kirupa.com/t/delete-multiple-entries-using-mysql/22148/2 "2003-06-01T05:18:56Z")

</div>

oooooooh sorry… forgot all about this… i’m not really sure, I would try doing different querys…

$q1 = delete from table\_name where id = “11”  
$q2 = delete from table\_name where id = “12”  
$q3 = delete from table\_name where id = “13”

$r1 = mysql\_query($q1);  
$r2 = mysql\_query($q2);  
$r3= mysql\_query($q3);

something like that would work.

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [June 1, 2003, 5:40am UTC](https://forum.kirupa.com/t/delete-multiple-entries-using-mysql/22148/3 "2003-06-01T05:40:30Z")

</div>

this is how i usually do it:

```php
<?php
$deleteArray[0]=11;
$deleteArray[1]=12;
$deleteArray[2]=13;
mysql_connect('localhost', 'root');
mysql_select_db('mydb');
for ($i=0; $i<2; $i++) {
$id_num = $deleteArray[$i];
$query = "DELETE FROM table WHERE id_num='$id_num'";
$result = mysql_query($query);
echo "$id_num is deleted! <**br>";
}
?>

```

… you might be fine though using jubba’s way, i used the array way cause i had a lot of non-consecutive records that i needed to delete 🙂

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [June 1, 2003, 6:39am UTC](https://forum.kirupa.com/t/delete-multiple-entries-using-mysql/22148/4 "2003-06-01T06:39:58Z")

</div>

yeah, I like his way better. 🙂