[EMAIL PROTECTED] writes: > database,sql,query,table Fscking piece of crap filter. :-P Why not just forbid posts from people not on the list and have new members approved manually? Nooo... must annoy the users. Blaergh.
> > I'd like to be able to get back all of the IDs that don't have 'blue', which would >be just ID 1. Obviously, this doesn't work: > > > > select * from color where data != 'blue'; > > You want to group by ID and get all IDs for which there > are 0 rows that have data='blue', right? > SELECT ID, sum(data='blue') as foo FROM color GROUP BY ID > HAVING foo=0 > should work. > > //C > > -- > Carl Troein - Círdan / Istari-PixelMagic - UIN 16353280 > [EMAIL PROTECTED] | http://pixelmagic.dyndns.org/~cirdan/ > Amiga user since '89, and damned proud of it too. --------------------------------------------------------------------- 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
