Search my own answer posts...

2

Please login or register to vote for this query.

(click on this box to dismiss)

This query returns the linked list of your answers partially matching the entered body text. Search is not case sensitive. The UserID parameter is your user ID (by default prefilled with your user ID) and the PostText is the text which you want to search for.

Emacs

Q&A for those using, extending or developing Emacs

DECLARE @MyUserID INT = ##UserID:int##
DECLARE @PostText nvarchar(600) = ##PostText:string##

SELECT @PostText = UPPER(@PostText)
SELECT
    Id AS [Post Link],
    Score AS [Score],
    CreationDate AS [Creation Date]
FROM
    Posts    
WHERE
    OwnerUserId = @MyUserID AND
    PostTypeId IN (2, 3) AND
    UPPER(Body) LIKE '%' + @PostText + '%'
ORDER BY
    CreationDate
DESC

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results