 | | | Query not returning Data | Query not returning Data 2007-10-10 - By Jay Blanchard
Back
[snip]
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;
[/snip]
Try WHERE type_help LIKE '%Eye Exam & Glasses%' and look at your dates
in the database themselves even if they are varchars, they are likely
formatted YYYY-MM-DD. Remove the limit first to make sure you are
returning data or make it more like LIMIT 60 first.
SELECT *
FROM Sight_Hearing_Help
WHERE type_help LIKE '%Eye Exam & Glasses'
AND board_action_date BETWEEN '2007-07-01' AND '2007-12-31'
LIMIT 0 , 60;
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
|