Skip to content

Instantly share code, notes, and snippets.

@Noitidart

Noitidart/stackoverflow-query-search-comments.txt

Last active May 20, 2020 01:17
Show Gist options
  • Save Noitidart/27bb64bdfcc00645a12c78c8c4f6c676 to your computer and use it in GitHub Desktop.
Save Noitidart/27bb64bdfcc00645a12c78c8c4f6c676 to your computer and use it in GitHub Desktop.
Download ZIP
Search for comments by tag of post
Raw
stackoverflow-query-search-comments.txt
// https://data.stackexchange.com/stackoverflow/query/1027054/search-posts-by-userid-comment-text?CommentText=ios&TagName=react-native
SELECT Posts.Id AS [Post Link], Comments.Text, Comments.CreationDate
FROM Comments
LEFT JOIN Posts ON Posts.Id = Comments.PostId
WHERE UPPER(Comments.Text) LIKE UPPER('%##CommentText##%')
AND Comments.UserId = '1828637'
AND Posts.Tags LIKE '%<##TagName##>%'
ORDER BY Comments.CreationDate DESC
@Noitidart
Copy link
Author

Noitidart commented May 6, 2019 •
edited
Loading

search within favorites - https://stackapps.com/questions/2438/stack-favorites-a-basic-organizer-of-your-stack-overflow-favorites

https://antonpantev.com/projects/stackfavorites/

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment