>I have a database of files. In the database is information about the app
>that produced the file.
>
>I want to list the top 5 producers. If I do:
>
>distinct(Producer), count(*) as Documents from data where Producer is not
>null group by Producer order by Documents desc limit 5;
>
>This works, but it differentiates between 'PageMaker 6.0', 'PageMaker 5.0',
>etc. I want it to show the top 5 and if there are different versions, to
>collapse them.
>
>Any way to do this in MySQL?
Store the product name and version number in seprate fields.
-or-
Instead of selecting Producer, select SUBSTRING_INDEX(Producer, " ", 1).
>
>Thanks,
>
>Michael
>
>P.S. Please reply directly to me and not the list as I am not a subscriber
>to the list.
--
Paul DuBois, paul@stripped

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.