Search in user's profile text, by several keywords


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 
--      <>?)
--   2. XXXX

      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.Views > 100 AND  
      u.AboutMe LIKE '%PostGresql%'

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

ORDER BY [Repuration points] DESC

Enter Parameters

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