List:General Discussion« Previous MessageNext Message »
From:Brent Baisley Date:October 13 2007 11:57am
Subject:Re: Query not returning Data
View as plain text  
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@stripped
>

Thread
Query not returning Datarussbucket10 Oct
  • RE: Query not returning DataTimothy Little10 Oct
  • Re: Query not returning DataStut10 Oct
  • Re: Query not returning DataMartijn Tonies10 Oct
    • Re: Query not returning DataBrent Baisley13 Oct