Search in user's profile text, by several keywords

0

Please login or register to vote for this query.

(click on this box to dismiss)

Search in user's profile text, by several keywords

Japanese Language Meta

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Japanese language

-- Free text search in users' free profile text (field "About me")
--
-- Note: In this first version, the search for several 
--       keywords (with user input) has not been 
--       implemented (the initial impetus was 
--       fullfilled by the hardcoded value)
--
--
-- Future: 
--
--   1. In the result page, make ***live links*** to the
--      user profiles 
--
--      Can we do it like in 
--      <https://data.stackexchange.com/stackoverflow/query/164178>
--      ?
--
--   2. XXXX

SELECT TOP 100
      u.DisplayName as [Name],
      u.Id          as [User ID],
      u.Reputation  as [Repuration points],
      u.WebsiteUrl  as [Home page],
      u.Location    as [Location]

FROM Users u

-- User input (associating the identifier with the actual user prompt):
--   Keyword1: Keyword 1
--   Keyword2: Keyword 2

WHERE
      u.AboutMe LIKE ##Keyword##

      -- User input: ##Keyword1:string##
      -- User input: ##Keyword2:string##

ORDER BY [Repuration points] DESC

--Keyword:Keyword:

Enter Parameters

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