russbucket wrote: > 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 Additional information: SUSE 10.2, MySQL 5.9.26-14 -- 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]