Simple mySQL DELETE question

[poisa]

Hi all,

Is there a way to delete multiple rows with a single mySQL query?

For example:
I want to delete rows with IDs 5, 9, and 64.
Is it possible to do it with one query? Or do I have to create a function and call it 3 times?

Cheers,
Poisa

[cgraz]

use mysql's IN

$query = mysql_query("DELETE FROM your_table WHERE id IN('5','9','64')");

Cgraz

[poisa]

Thanks!

That's exactly what I needed.