Questions where title = body

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

select top 1000  pht.postid as [Post Link]
from posthistory pht 
where pht.posthistorytypeid = 1 -- title
and pht.text = (select text
  from posthistory phb 
  where phb.postid = pht.postid
  and phb.posthistorytypeid = 2 -- body
)
and pht.creationdate > '2019-01-01'

Enter Parameters

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