# \[MySql\] sort by frenquency

**URL:** <https://forum.kirupa.com/t/mysql-sort-by-frenquency/168726>\
**Category:** programming\
**Created:** [November 9, 2005, 3:52pm UTC](https://forum.kirupa.com/t/mysql-sort-by-frenquency/168726 "2005-11-09T15:52:38Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Seticus](https://avatars.discourse-cdn.com/v4/letter/s/46a35a/32.png) [@Seticus](https://forum.kirupa.com/u/Seticus)\
**Post date:** [November 9, 2005, 3:52pm UTC](https://forum.kirupa.com/t/mysql-sort-by-frenquency/168726/1 "2005-11-09T15:52:38Z")

</div>

i’m a bit new to mysql, searched the net, but could really find anything:  
I’ve got a table with 3 fields: “id”, “title” and “userid”. Someone can post a title and then his username and the tile are added to the table. What I want to do now is print the titles sorted by frequency of occurrance.

It seems to me you have to use subqueries to solve this problem.

Thanks