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