You should also get rid of the quotes, so MySQL doesn't have to convert from string to integer:
SELECT team_id,name FROM team WHERE deleted != 1 ORDER BY 'name' --jeff ----- Original Message ----- From: "Steve Buehler" <[EMAIL PROTECTED]> To: "Keith C. 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 -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 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 WHERE deleted <> '1' ORDER BY 'name' > > > > > > the deleted column is: > > > deleted tinyint(1) unsigned default NULL, > > > >You probably want to make the column NOT NULL, so that false is > >represented by 0. Read these to see how using NULL complicates > >things in SQL: > > > >http://www.mysql.com/doc/W/o/Working_with_NULL.html > >http://www.mysql.com/doc/P/r/Problems_with_NULL.html > > > >-- > >Keith C. Ivey <[EMAIL PROTECTED]> > >Tobacco Documents Online > >http://tobaccodocuments.org > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
