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

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);

fork query

created may 27 10 sth