Check here: http://dev.mysql.com/doc/mysql/en/Comparison_Operators.html
Look for the IN and NOT IN comparators :-)
DELETE FROM the_table WHERE `ID` IN(1,2,3,4,5,6)
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
-{ Rene Brehmer }- <[EMAIL PROTECTED]> wrote on 11/02/2004
07
: -{ Rene Brehmer }- <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: [PHP-DB] Using an array(-ish) in SQL queries
Date: Wed, 03 Nov 2004 01:29:20 +0100
X-posted to MySQL and PHP DB
Hi gang
Task at hand: deleting or selecting (same difference) several numbers of
records using
-- Original message --
From: -{ Rene Brehmer }- <[EMAIL PROTECTED]>
> Task at hand: deleting or selecting (same difference) several numbers of
> records using only 1 query.
>
> My first version simply looped through all the ticked off IDs and ran a
> single query
X-posted to MySQL and PHP DB
Hi gang
Task at hand: deleting or selecting (same difference) several numbers of
records using only 1 query.
My first version simply looped through all the ticked off IDs and ran a
single query for each delete routine. I've still not suceeded in getting
the delete q