Yes, Even Numbers: SELECT * FROM table WHERE MOD(id,2) = 0;
Odd Numbers: SELECT * FROM table WHERE MOD(id,2) != 0; - Jonathan -----Original Message----- From: Jeremy Peterson [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 11:59 AM To: Raymond Lilleodegard; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Query with numbers like 1, 3, 5.......... select * from table where id in (1,3,5,10,'etc') At 08:22 PM 2/7/2002 +0100, Raymond Lilleodegard wrote: >Hi! > >Is there a way to get the rows with id's like 1, 3, 5, and so on or 2, 4, 6, >...........? > > >Best regards Raymond > > > >-- >PHP Database Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
