3

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for those who study, teach, research and apply economics and econometrics

--Looks for the input sequence of characters to appear somewhere in the 
--AboutMe section of a StackOverflow profile, and returns results in 
--descending order by reputation.
SELECT * 
FROM Users
WHERE 
LOWER(AboutMe) LIKE '%' + ##keyword:string## + '%' 
AND reputation >1
AND NOT LOWER(AboutMe) LIKE '%' + ##keyword:string## + 's%'
ORDER BY reputation DESC

fork query

edited sep 12 19

created sep 12 19 selllikesybok