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 NOT (Body LIKE '%##Pattern##%' OR Title LIKE '%##Pattern##%')
  AND (NOT (##UserId## > 0) OR OwnerUserId = ##UserId##)
ORDER BY Id ASC

fork query

created jun 11 11 Gilles