 |
 |
 |
 |
|
|
Date: 11/15/00
- Next message: Steven Holloway: "RE: [PHP] Dreamweaver 4 ignores PHP - again"
- Previous message: Ben Wiechman: "[PHP] MySQL SELECT question"
- Maybe in reply to: Ben Wiechman: "[PHP] MySQL SELECT question"
- Next in thread: John LYC: "Re: [PHP] MySQL SELECT question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> Can I use multiple where clauses in a select statement?
> i.e.
>
> SELECT FROM table WHERE this = 'that'AND thishere = 'thatthere'
Certainly! You'll need a space between the ' and the AND though.
For complex WHERE statment you'll want to be introduced to your good
friend, the bracket. :)
> Is it possible to match, for example, only the month?
>
> SELECT * FROM table WHERE FORMAT_DATE( DATE, %m ) = '<value
> from 1-12 here>'
Hmmm, good one - not sure cos I've never done date stuff before. Maybe
someone else can help you (I store unix timestamps).
Jason
-- 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>
- Next message: Steven Holloway: "RE: [PHP] Dreamweaver 4 ignores PHP - again"
- Previous message: Ben Wiechman: "[PHP] MySQL SELECT question"
- Maybe in reply to: Ben Wiechman: "[PHP] MySQL SELECT question"
- Next in thread: John LYC: "Re: [PHP] MySQL SELECT question"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]