How you can get a list of all the comments you have written? There is the "recent" -tab in user information but that lists only the 50 or so last events.


4 Answers 4


The way to do this now is to go to your activity tab and then select the comments grouping.

This will show them, most recent first, paginated.


Go here:


Enter this as a query:

select * from comments where userid = 1431
  • @shog9: Very nice, I wasn't sure if it supported that.
    Aug 5, 2009 at 20:13
  • is there anyway to see the votes you have in a comment? is that included in the dump? Aug 5, 2009 at 21:01
  • @Paolo: No.
    Aug 5, 2009 at 21:02
  • @orique: The answer is from 2009...
    Nov 8, 2013 at 14:38
  • 1
    You can now. The comments table has a score column containing the number of upvotes. (I suppose that's what orique's now deleted comment said?)
    – Adi Inbar
    Nov 24, 2014 at 18:56
  • @PaoloBergantino this one sorts by comment votes --> data.stackexchange.com/stackoverflow/query/415462/… Nice shot in the arm to go back and see what resonated. (Remember to use user NUMBER not name.)
    – Bob Stein
    Nov 6, 2017 at 23:37
  • The query explorer does not work, it does not fire. Nov 8, 2020 at 8:18
  • @user312: Yes it does. The site is working fine.
    Nov 10, 2020 at 16:41

You could extract them from the data dump.


The only logical way would be through the data dump. Right now there is no other mechanism in the system to go back and time and see all of your comments. Unless you wrote some kind of script that trolled through every one of your questions and answers and looked for comments you wrote.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .