Re: [PHP] MySQL SELECT question From: John LYC (john <email protected>)
Date: 11/15/00

this might be of some help

 http://www.mysql.com/documentation/mysql/commented/

you can do a search on time or date functions....
there are lots more..
eg : dayofmonth().. or .. month()..... etc...

one disadvantage of inserting a unix timestamp instead of a yyyy-mm-dd format is
that there is a limitation.. but it 's far from now.... a yyyddmm format gives
more flexibility....
but then again... a unix timestamp can be much more precise and date arithmetic
can be done easily in some cases...

[john]

Ben Wiechman wrote:

> Since I couldn't seem to uncover a decent example...
>
> Can I use multiple where clauses in a select statement?
> i.e.
>
> SELECT FROM table WHERE this = 'that'AND thishere = 'thatthere'
>
> And another question...
>
> I have a date field in my table
>
> Is it possible to match, for example, only the month?
>
> i.e.
>
> SELECT * FROM table WHERE FORMAT_DATE( DATE, %m ) = '<value from 1-12 here>'
>
> Thanks
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe <email protected>
> For additional commands, e-mail: php-general-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>