Skip to content

Instantly share code, notes, and snippets.

@moritz
Created August 6, 2011 11:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save moritz/1129286 to your computer and use it in GitHub Desktop.
Save moritz/1129286 to your computer and use it in GitHub Desktop.
who down-karma'd masak?
mysql> select nick, count(nick) from irclog where line like '%masak--%' group by nick;
+-------------+-------------+
| nick | count(nick) |
+-------------+-------------+
| dalek | 4 |
| egonw | 8 |
| evalbot6 | 1 |
| jnthn | 1 |
| jonalv | 8 |
| masak | 19 |
| Matt-W | 1 |
| moritz_ | 2 |
| olas | 3 |
| olass | 6 |
| sorear | 1 |
| Wolfman2000 | 2 |
+-------------+-------------+
12 rows in set (9.66 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment