kus
- Original Message -
From: "leegold" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 07, 2004 4:51 AM
Subject: select and where clause - help
> I am trying to get a select statement with "WHERE" to work and
> I can't seem to do
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
I am trying to get a select statement with "WHERE" to work and
I can't seem to do it. Below find some output. I try a select
w/WHERE by "book" but it doesn't work. Originally I tried
in PHP and didn't work, so now I just want the MYSQL to work first, I
could be overlooking something simple since I'
. 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. Th
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
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 deleted != '1' ORDER BY 'name'
SELECT team_id,name FROM team
