RE: [PHP-DB] Date function.
| From: | Dave Fudge | Date: | Fri, 19 Jan 2001 17:02:04 +0000 |
| Subject: | RE: [PHP-DB] Date function. | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-5992@lists.php.net to get a copy of this message | ||
select * from BIRTHDAYS where substr(Date,5,2) = '07';
-----Original Message-----
From: Sharif Islam [mailto:mislam@students.uiuc.edu]
Sent: Friday, January 19, 2001 11:56 AM
To: php-db@lists.php.net
Subject: [PHP-DB] Date function.
This is a simple mysql question i am having problme with.
I have a table with name and birth date;
--------------------
Joe | 1964-07-21
Mary | 1978-05-22
--------------
I want to get the name with birthdays in the month of July.
thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
For additional commands, e-mail: php-db-help@lists.php.net
To contact the list administrators, e-mail: php-list-admin@lists.php.net