Delete multiple records with one DELETE statement?

[bulrush]

Can I delete multiple records with one DELETE statement? Like this:

DELETE FROM table WHERE id=1 or id=2; 

 

I guess my alternative is, can I execute 2 delete statements in one PHP query command?

$query="DELETE FROM table WHERE id=1; ";
$query.="DELETE FROM table WHERE id=2; ";
$result=mysqli_query($dbc,$query);

[Mchl]

Yes you can. And no, the second one will not work. Only one query per one mysqli_query() call allowed.