0

Please login or register to vote for this query.

(click on this box to dismiss)

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>%'

fork query

created nov 7 11 burpenator