User-specific gendered comments

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu Meta

Q&A about the site for Ubuntu users and developers

SELECT 
  c.Text , c.PostId AS [Post Link]
FROM Comments c 
WHERE
  c.UserId = ##UserId## AND
  (
   c.Text LIKE '%[^a-zA-Z0-9][Hh]e[^a-zA-Z0-9]%' OR
   c.Text LIKE '%[^a-zA-Z0-9][Hh]im[^a-zA-Z0-9]%' OR
   c.Text LIKE '%[^a-zA-Z0-9][Hh]is[^a-zA-Z0-9]%' OR
   c.Text LIKE '%[^a-zA-Z0-9][Ss]he[^a-zA-Z0-9]%' OR
   c.Text LIKE '%[^a-zA-Z0-9][Hh]er[^a-zA-Z0-9]%'
)

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results