OTECTED]>
Sent: Sunday, June 23, 2002 8:58 AM
Subject: Re: Strings query question
> Thanks, that worked for song named "Empire", however,
> when I checked other song names such as songname
> called "One" I get two results:
>
> | id | songname |
* [EMAIL PROTECTED]
> Thanks, that worked for song named "Empire", however,
> when I checked other song names such as songname
> called "One" I get two results:
>
> | id | songname |
> +++
> | 35 |
> You're Still The One |
> | 57 |
> One |
just my 0,02
>
> jan
>
>
> - Original Message -
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Sent: Sunday, June 23, 2002 2:27 PM
> Subject: Strings query question
>
>
> I do not understand string comparison. Why doesn't the
> followin
I do not understand string comparison. Why doesn't the
following work:
SELECT id, songname FROM songs WHERE songname = "Empire";
All I get is: Empty set (0.00 sec)
I know the string exists in the database:
In record 135 exists:
Empire |
| 135 |
Do I have