MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:bharani kumar Date:January 17 2010 9:00am
Subject:query returning empty row
View as plain text  
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)



Thanks

Thread
query returning empty rowbharani kumar17 Jan
  • Re: query returning empty rowDan Nelson18 Jan
    • Re: query returning empty rowbharani kumar18 Jan
      • Regarding storing non-english chars in mysqlNingappa  Koneri18 Jan
        • RE: Regarding storing non-english chars in mysqlGavin Towey18 Jan
          • Re: Regarding storing non-english chars in mysqlfsb18 Jan
            • RE: Regarding storing non-english chars in mysqlNingappa  Koneri19 Jan
              • Re: Regarding storing non-english chars in mysqlfsb19 Jan
                • RE: Regarding storing non-english chars in mysqlJerry Schwartz19 Jan