Date: 04/13/05 (MySQL Communtiy)    Keywords: mysql, sql

SELECT * from schedule WHERE (clientid = 95145) AND (date BETWEEN '2005-04-10' AND '2005-04-30') ORDER BY date

Any one know of a good site with a elaborate description of the WHERE clause of the SELECT statement? I am trying to select data that matches a client id and a date range. The MySQL manual doesn't seem to get into it in detail.

I got it to work. I had left out the quotes. Sheesh.

Source: http://www.livejournal.com/community/mysql/54122.html