MySQL SELECT question
| From: | Ben Wiechman | Date: | Thu, 16 Nov 2000 01:00:13 +0000 |
| Subject: | MySQL SELECT question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-25565@lists.php.net to get a copy of this message | ||
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