query attempts to exclude emoticons by matching </p> immediately following the hyphen thanks to this answer for the terminology: http://english.stackexchange.com/questions/31060/#31091
Q&A for anime and manga fans
-- Posts containing "the dog's bollocks" (a colon immediately followed by a hyphen) -- query attempts to exclude emoticons by matching </p> immediately following the hyphen -- thanks to this answer for the terminology: http://english.stackexchange.com/questions/31060/#31091 select top 100 id as [Post Link], creationdate from posts where body like '%:-</p>%' or title like '%:-</p>%'