Ken,

Check out DAYOFMONTH() and MONTH() and a wealth of other useful date
functions. RTFM: 6.3.4 Date and Time Functions

The answer to your question about AUTO_INCREMENT 'reset' can be found at
6.5.3 CREATE TABLE Syntax under "table_options".

Regards,
=dn


> I have a test table with the ususal  customer information in it along
with a
> field for the date of birth. I'm trying to return records of any
customers
> whose birthdates are the same day and month as the current date.
> Here's the query & result:
> mysql> SELECT * FROM Cinfo WHERE BirthDate  = "date('m d')";
> Empty set (0.00 sec)
> Here's what is returned with a global query:
> mysql>  select * from Cinfo;
>
+-----------+----------+-------------------+---------+-------+--------+-
-------------+--------------+--------------+------------+----+
> | FirstName | LastName | Address           | City    | State | Zip
|
> HomePhone    | WorkPhone    | CellPhone    | BirthDate  | id |
>
+-----------+----------+-------------------+---------+-------+--------+-
-------------+--------------+--------------+------------+----+
> | Joe       | Blow     | 1200 High St. #12 | St.Looy | UT    | 844110
|
> 801-111-2299 | 801-111-3456 | 801-213-8956 | 1959-03-01 |  1 |
> |           |          |                   |         |       |
|
>        |              |              |            |  2 |
> |           |          |                   |         |       |
|
>        |              |              |            |  3 |
> |           |          |                   |         |       |
|
>        |              |              |            |  4 |
>
+-----------+----------+-------------------+---------+-------+--------+-
-------------+--------------+--------------+------------+----+
> 4 rows in set (0.00 sec)
>
> I have a feeling it's the date format in the table. I tried making it
a date
> field but just got the current date. What am I doing wrong?
> Off Topic,  I saw something about resetting the auto-increment
counter, but
> now I can't find reference to it. Can some kind soul enlighten me???
> --
>
>
> Ken Thompson, North West Antique Autos
> Payette, Idaho
> Email: [EMAIL PROTECTED]
> http://www.nwaa.com
> Sales and brokering of antique autos and parts.
>
> Linux- Coming Soon To A Desktop Near You
> Registered Linux User #183936
>
> --
> 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

Reply via email to