Hi
i've a particular select to do... here is the order i want : select *,count(*) as counted from database group by field_to_count order by counted this query works but only returns one record per field_to_count (normal behaviour) i would want to get all the records (so, "group by" doesn't affect the record set), but keep this order... sort of "order by count(field_to_count grouped)" is this possible ? thanks PS : i'm using mysql 3.23 -- .thibaut allender ~ dev:network. @ magic:sq. .tel. : +32 2 / 209 83 71 ~ http://magicsquare.be --------------------------------------------------------------------- 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