I'm trying to find a particular comment thread on an old post of mine. Unfortunately, the search box in the top-right only searches through answers, not comments, and Googling doesn't help because most comments end up hidden behind the "show comments" link. Is there any way to search for it?
The only thing that I can think of is to use the Stack Exchange Data Explorer. Comments are second-class citizens and aren't searchable, not well-index by Google, and extended discussions can be cleaned up with no warning (moderators are alerted to any post with large numbers of comments and can remove any comments that are noisy).
You can use this query. If you're logged in it should autofill the UserId parameter. The text parameter uses SQL syntax. For example, if you want to search for "SQL" anywhere in your comment, enter "%SQL%".