1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT Tags.TagName, Tags.Count, Posts.Body FROM Tags, Posts
  WHERE Posts.Id = Tags.ExcerptPostId
  AND (
    Posts.Body LIKE '%DO NOT USE%' OR
    Posts.Body LIKE '%Do Not Use%' OR
    Posts.Body LIKE '%do not use%' OR
    UPPER(Posts.Body) LIKE '%DO NOT USE%'
  )
  ORDER BY Tags.Count DESC;

view current version

edited jan 18 15

created jan 18 15 Kevin Brown