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 board_action_date is a varchar
field.
Not
a date field. I have also tried using form 2007-07-01.
Additional information:
SUSE 10.2, MySQL 5.0.26-14
Any help would be appreciated!
It could be me, but aren't you compareing a string to a string?
'type_help' (with normal single quotes) is a string value.
"Eye Exam & Glasses" can be a string value as well in MySQL,
although you
should always use single quotes.
Oh, and a reminder: to solve your strange date-format problems,
just store a
date in a DATE-type column.
Martijn Tonies
Database Workbench - development tool for MySQL, and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
