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.