Gerry Danen wrote:
While I am rebuilding my crashed laptop (the machine that had all my
intelligence), I started thinking about a select statement I need.

I have log info in a table and want to extract it on a monthly basis. The
date field is in yyyy-mm-dd format. What's a good way to select those dates
that match 2006-02, for example.

I apologize if the solution should be staring me in the face, but all my
favorites and help files are toast, until I can restore some of them.

Which database are you using?

Mysql has this:

Postgresql has:

I'm sure others have the same sort of functionality.

Postgresql & php tutorials

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to