That is a string comparison, so they will never be equal. You don't
have to put quotes around field names unless you are using reserved
words, which you shouldn't. If you do use "quotes" around field
names, you need to use `backticks`.
On Oct 10, 2007, at 1:15 PM, Martijn Tonies wrote:
> Sorry about double post, I am having problems with my ISP.
>
> 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 boar
russbucket wrote:
Sorry about double post, I am having problems with my ISP.
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 boa
nal Message-
> From: russbucket [mailto:[EMAIL PROTECTED]
> 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 't
(return a non-empty result-set) when you omit the
board_action_date BETWEEN comparator clause?
Tim...
-Original Message-
From: russbucket [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 10, 2007 11:06 AM
To: mysql@lists.mysql.com
Subject: Query not returning Data
Sorry about double
Sorry about double post, I am having problems with my ISP.
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 v
[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 ar
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 da
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