|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
Re: Query not returning Data
From: russbucket (russbucket
nwi.net)
Date: Wed Oct 10 2007 - 10:01:11 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]