We may earn a small commission from affiliate links and paid advertisements. Terms
SELECT author_name, count(*) as `thecount` FROM invision_posts
where post LIKE '%fuck%'
group by author_name
order by thecount desc
Quoted post[/post]]
It would be nice if you could divide those posts by a users total posts to see how fowl they are consistently.