MySQL delete multiple rows in one query conditions unique to each row You were very close, you can use this: Please see this fiddle.