On 21 Dec 2001, at 15:57, Carsten H. Pedersen wrote: > SELECT DISTINCT enum_col FROM tablename WHERE enum_col<256;
But that's only if you have at least one record representing each possible value, right? It wouldn't work on an empty table, for example. By the way, what's the purpose of the WHERE clause? Aren't enumerated column values always less than 256? Am I missing something? -- Keith C. Ivey <[EMAIL PROTECTED]> Washington, DC --------------------------------------------------------------------- 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