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