RE: [PHP-DB] Query with numbers like 1, 3, 5..........
| From: | Jonathan Hilgeman | Date: | Thu, 07 Feb 2002 20:05:04 +0000 |
| Subject: | RE: [PHP-DB] Query with numbers like 1, 3, 5.......... | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-16625@lists.php.net to get a copy of this message | ||
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:jpeterso@moody.edu]
Sent: Thursday, February 07, 2002 11:59 AM
To: Raymond Lilleodegard; php-db@lists.php.net
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