Q:

Data Explorer query to find answers of specific user based on a keyword

I'm looking for SQL query to use within Data Explorer, to bring back all my answers (per site, from only one site at a time) with my userid and with a particular keyword, in the body of my answers.
I do not need to do this cross-site or SE communities.

A:

Here you go:
Select Id As [Post Link], CreationDate
From Posts
Where PostTypeId=2 --Answers
    And OwnerUserId=##UserId##
    And Body Like '%##keyword##%'
Order By CreationDate Desc

Sample search.

