Hi,
> | BT-1034.02
> mysql> SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.2';
I think you have a type .. instead of
SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.2'
try
SELECT * FROM balloon_txt WHERE access_no = 'BT-1034.02'
HTH, Markus
- Original Message -
From: "leego
On Tue, 06 Jul 2004 23:24:13 -0400,
[EMAIL PROTECTED] said:
> from your output it's not really possible to tell, but i suspect that
> there are spaces following (and/or possibly in front of) the
> "BT-1034.02" value, which would cause your select to fail to find
> anything.
>
> try:
>
> SEL
. Ivey" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 3:00 PM
Subject: Re: SELECT and WHERE clause
> That did the trick. That just seems like it shouldn't have to be that
way.
>
> Thanks a LOT
> Steve
>
> At 05:50 PM 5/23/2002
try
SELECT team_id,name FROM team WHERE deleted <> 1 ORDER BY name
-Original Message-
From: Steve Buehler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 23, 2002 3:20 PM
To: [EMAIL PROTECTED]
Subject: SELECT and WHERE clause
Ok. I can NOT find out what I am doing wrong. The book makes
That did the trick. That just seems like it shouldn't have to be that way.
Thanks a LOT
Steve
At 05:50 PM 5/23/2002 -0400, Keith C. Ivey wrote:
>On 23 May 2002, at 15:20, Steve Buehler wrote:
>
> > Ok. I can NOT find out what I am doing wrong. The book makes it look
> like
> > any of these w
On 23 May 2002, at 15:20, Steve Buehler wrote:
> Ok. I can NOT find out what I am doing wrong. The book makes it look like
> any of these would work (deleted is a column name):
> SELECT team_id,name FROM team WHERE deleted NOT LIKE '1' ORDER BY 'name'
> SELECT team_id,name FROM team WHERE dele
