Hi, 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 > > SQL is close to natural english so let's rewrote your sentence a little. Assuming you have table patients and collumn addmitted - WHERE clause you need will be:
select ... from patients WHERE admitted BETWEEN '2000-01-25' AND '2000-01-30'; -- Best regards -- For technical support contracts, visit https://order.mysql.com/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Alexander Keremidarski <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer /_/ /_/\_, /___/\___\_\___/ Sofia, Bulgaria <___/ www.mysql.com M: +359 88 231668 --------------------------------------------------------------------- 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
