1

Please login or register to vote for this query.

(click on this box to dismiss)

Find comments of a specific user by text.

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

SELECT Comments.PostId , Comments.Text 

FROM Comments

WHERE
     (Comments.UserId=##User:int##) AND
      lower(Comments.Text) LIKE lower('%##Text##%')

view current version

edited mar 1 12

created mar 1 12 Remou