Query not returning Data 2007-10-13 - By Brent Baisley
Back
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?
> unsub=brenttech@(protected)
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@(protected)
|
|
