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.


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. – GEOCHET Aug 5 '09 at 20:13
  • is there anyway to see the votes you have in a comment? is that included in the dump? – Paolo Bergantino Aug 5 '09 at 21:01
  • @Paolo: No. – GEOCHET Aug 5 '09 at 21:02
  • @orique: The answer is from 2009... – GEOCHET Nov 8 '13 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 '14 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 '17 at 23:37
  • The query explorer does not work, it does not fire. – user3123159 Nov 8 '20 at 8:18
  • @user312: Yes it does. The site is working fine. – GEOCHET Nov 10 '20 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 .