Re: Strings query question

2002-06-23 Thread Gurhan Ozen
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 |

Re: Strings query question

2002-06-23 Thread Roger Baklund
* [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 |

Re: Strings query question

2002-06-23 Thread testacct
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

Strings query question

2002-06-23 Thread testacct
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