1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for linguists, teachers, and students wanting to discuss the finer points of the Latin language

SELECT  SUBSTRING(body, PATINDEX('%://xkcd.com/[0-9]%', body), 10)
FROM    (
        SELECT  TOP 200000
                body
        FROM    posts
        ORDER BY
                id DESC
        UNION
        SELECT  TOP 1000000
                text
        FROM    comments
        ORDER BY
                id DESC
        ) q
WHERE   body LIKE '%://xkcd.com/[0-9]%'

view current version

edited jul 9 14

created jul 9 14 Quassnoi