OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Query not returning Data

From: russbucket (russbucketnwi.net)
Date: Wed Oct 10 2007 - 09:57:47 CDT

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