Dra. Silvia Andreasi, SELECT * FROM table WHERE begin_date_column <=2000-01-25 and 2001-01-30<= end_date_column;
begin_date_column and end_date_column have to be date type columns. Mike sql,mysql Dra. Silvia Andreasi wrote: > Hi, > > How can I get the columns between a given time interval? Something like: " > The patients admitted between january 25, 2000 and january 30, 2001" > ?????? > > I'm new to MySql and would like a suggestion from you... > > Best Regards > > Silvia > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > -- Mike --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
