Have you tried testing the two parts of your WHERE clause separately? Regards,
Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com > -----Original Message----- > From: russbucket [mailto:[EMAIL PROTECTED] > Sent: Wednesday, October 10, 2007 10:58 AM > To: mysql@lists.mysql.com > Subject: Query not returning Data > > I have the following query: > > SELECT * > FROM Sight_Hearing_Help > WHERE 'type_help' = "Eye Exam & Glasses" > AND 'board_action_date' BETWEEN "07-01-2007" AND "12-31-2007" > LIMIT 0 , 60; > > Returns empty row every time. The board_action_date is a varchar field. > Not > a date field. I have also tried using form 2007-07-01. > > Any help would be appreciated! > > Thank you > -- > Russ > Registered Linux user #441463 > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > infoshop.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
