0

Please login or register to vote for this query.

(click on this box to dismiss)

Search for posts containing a specific string anywhere. Optionally restrict to a specific user (enter 0 for anyone).

Q&A about the site for members of the workforce navigating the professional setting

-- Substring search
-- Search for posts containing a specific string anywhere.
-- Optionally restrict to a specific user (enter 0 for anyone).

SELECT
  Id as [Post Link],
  OwnerUserId As [User Link],
  CreationDate As [Date]
FROM Posts
WHERE (((Body LIKE '%##Pattern##%')))
  AND ((NOT (##UserId## > 0)) OR (OwnerUserId = ##UserId##))
ORDER BY Id ASC

fork query

created jun 11 11 Gilles