get total post count

[kalster]

I have a mysql table like the following.

 

post   | username

______________

post1 | username1

post2 | username2

post3 | username1

 

I need a mysql count or max query that would get the highest post count of a user. At the table above, the post count would be 2 because username1 posted two times. Both the post and username data are unknown.

[PravinS]

Try this query

SELECT username, count(username) AS post_count FROM TABLE_NAME 
GROUP BY username
ORDER BY count(username) DESC;

you can apply LIMIT to get top records, as query will give sorted result according to max post count of user.

[kalster]

That gives me the user with the highest post count. What i need is the post count of the user that posted the most.