> The table has something like this: > > id name key > 1 name1 key1 > 2 name2 key2 > 3 name3 key3 > 4 name1 key1 > 5 name 1 key1 > 6 name2 key2 > > > Now I want to search the table for all unique name/key combinations. > select name,key from table group by name,key; > Second, how do I translate my "logic" above into SQL? Or should I do it > in PHP? You should do it inPHP
-- _/ _/ _/_/_/ ----- Rafał Jank [EMAIL PROTECTED] ----- _/ _/ _/ _/ _/ Wirtualna Polska SA http://www.wp.pl _/_/_/_/ _/_/_/ ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625 _/ _/ _/ --------==* http://szukaj.wp.pl *==---------- --------------------------------------------------------------------- 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