thanks for reply, problem fixed,
On Mon, Jan 18, 2010 at 6:06 AM, Dan Nelson <dnel...@allantgroup.com> wrote: > In the last episode (Jan 17), bharani kumar said: > > SELECT updateDate,cHospital,cHospital1,cHospital2 FROM med_patient WHERE > > cCurstatus!='completed' AND cMmrcashworker = '2' AND > > (cHospital = '1234' OR cHospital1 = '1234' OR cHospital2 ='1234') AND > > updateDate between '2010-01-01' and '2010-01-28' order by id desc > > > > I have one patient entry,and his updateDate is 2010-01-17 , > > > > but my above query return empty row , Why ? > > > > ( Note --> my updateDate field is varchar type) > > Perhaps his hospital ID is not 1234, or cMmrcashworker is not 2, or > cCurstatus = 'complete'. Try > > SELECT > updateDate,cCurstatus,cMmrcashworker,cHospital,cHospital1,cHospital2 > FROM med_patient WHERE updateDate between '2010-01-01' and '2010-01-28' > order by id desc > > and verify that the other fields in your WHERE clause have the values you > think they do. > > -- > Dan Nelson > dnel...@allantgroup.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=bharanikumariyer...@gmail.com > > -- Regards B.S.Bharanikumar http://php-mysql-jquery.blogspot.com/
