SEO

#1 (**permalink**) 02-28-2008, 07:01 AM

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

#2 (**permalink**) 02-28-2008, 07:01 AM

[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;

#3 (**permalink**) 02-28-2008, 07:01 AM

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:russbucket@nwi.net]
> 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/mysql?unsub=jschwartz@the-
> infoshop.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode