delete multiple rows from single query ?

[mykg4orce]

yes, exactly as the topic says....im wondering if i can do sumthing like the following::

DELETE FROM users WHERE id ="$user_ids'

and the variable "$user_ids" contains the following string ::

"1,2,3,4,5"

The only way out of this seems to write separate delete queries or write a loop. But i hope SQL has a syntax that supports wat i want to do (fingers crossed)

thanks in advance...

[ahundiak]

Lookup the IN portion of the WHERE clause.

[mykg4orce]

thanks for the clue...

"DELETE FROM users WHERE id IN (1,2,3)"

works like a charm.. :>

Actually i had tried that before but i put single quotes inside the brackets and i guess sql did not like that 😛 oh well....