Q&A for administrators and users of the CiviCRM Constituent Relationship Management software
select top 200 Concat('https://stackoverflow.com/questions/', c.PostId), c.Text from Comments as c inner join Posts as p on c.PostId = p.Id and p.PostTypeId = 2 where c.Text like '%thank%work%for%me%'