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

Q&A for those involved in the field of teaching Computer Science

-- 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 '%Imperial College%'

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

ORDER BY [Repuration points] DESC

fork query

edited dec 1 anonymous

created may 24 10 sam.saffron