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 > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> 1.2 million kids a year are victims of human trafficking. Stop slavery. http://us.click.yahoo.com/.QUssC/izNLAA/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/
