[PHP] MySQL SELECT question From: Ben Wiechman (neteru <email protected>)
Date: 11/15/00

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>