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