How about SELECT (column1, column2, column3, etc.) FROM products... I believe something along the lines of EXCEPT FOR would be a huge violation of SQL standards. It might be useful for you, but it's likely that most users would simply declare the desired columns or exclude one programatically.
Edward Dudlik Becoming Digital www.becomingdigital.com ----- Original Message ----- From: "Jed Hunsaker" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, 14 June, 2003 22:03 Subject: SELECT... EXCEPT FOR If there's not a way to do this I would suggest it be added to the next version of MySQL, but has anyone ever heard of an "EXCEPT FOR" clause that can be used in MySQL's SELECT statements? For instance... "SELECT * FROM products EXCEPT FOR colors WHERE sizes LIKE '%small%'" Thanks... Jed Hunsaker [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
