"Thank you" answers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Looking at posts shorter than 100 with the text `hank` somewhere in it

Stack Overflow

Q&A for professional and enthusiast programmers

-- "Thank you" answers
-- Looking at posts shorter than 100 with the text `hank` somewhere in it

select
   Id as [Post Link],
   body
from posts
where posttypeid = 2 and len(body) <= 100
  and (body like '%hank%')
order by len(body);

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results