Try Select * from employee where hiredate <= current_date() and hiredate >= (current_date() - interval 1 year);
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of aud_galaxy Sent: Monday, December 12, 2005 2:23 PM To: [email protected] Subject: [php_mysql] Re: newbie question Thanks for the reply, but I guess I should have stated that I wanted this to be dynamic... so if today is 12/12/05 I want it to give me everybody between 12/12/04 and 12/12/05. If I run the same query tomorrow (12/13/05) the query would give me everybody between 12/13/04 and 12/13/05. --- In [email protected], Jeromie Clark <[EMAIL PROTECTED]> wrote: > > SELECT * FROM employee WHERE hiredate >= '2005-01-01' AND hiredate <= > '2005-12-31'; > > > On Sun, 11 Dec 2005 5:18 pm, aud_galaxy wrote: > > Hi All, > > > > I'm using MySQL 4.x > > > > I have an Employee table: > > > > id > > name > > hiredate > > > > My question is how I would select everybody who were hired within a > > year. Thanks. > > > > KC > > > > > > > > > > > > > > The php_mysql group is dedicated to learn more about the PHP/MySQL web > > database possibilities through group learning. > > Yahoo! Groups Links > > > > > > > The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/CefplB/TM --------------------------------------------------------------------~-> The php_mysql group is dedicated to learn more about the PHP/MySQL web database possibilities through group learning. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php_mysql/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
