Q&A for professional and enthusiast programmers
select id as [Comment Link],creationdate, postid as [Post Link] from comments where text like '%happy new year%' escape '!'