Delete multiple rows with specific parameters in MySQL

Question

I wanted to know if is there any solutions to delete multiple rows in one query?

I'm using a select element with multiple input so I have an array in my $_POST when I'm sending my form.

For example, I want to unsubscribe an users from one table to more than one lesson So I have:

users.id | lesson.id
--------------------
1        | 1
1        | 2
1        | 3
1        | 4

My select post me an array with the lesson.id:

Array
(
    [0] => 2
    [1] => 3
    [2] => 4
)

How can I with only one query, delete all rows from my table ?

BTW, I know the users.id all the time.

Olaf Dietsche · Accepted Answer · 2012-12-11 00:04:26Z

2

If you want to delete just these three lesson_ids

delete from lesson_table
where users_id = 1 and lesson_id in (2, 3, 4)

If you want to delete all but one arbitrary lesson and you know, user 1 has 4 lessons, then you can limit the delete to 3 lesson_ids

delete from lesson_table
where users_id = 1
limit 3

answered Dec 10, 2012 at 23:55

Olaf Dietsche

74.4k9 gold badges113 silver badges214 bronze badges

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

1 Answer 1