0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

SELECT DISTINCT *
FROM Posts p
WHERE p.Tags like '%<java>%' AND
  (
    ( p.Tags like '%security%' 
      AND
      (
        p.Tags LIKE '%<android%'
        OR p.Tags LIKE '%<ios%'
      )
    )
    OR 
    (
    LOWER (p.Title) like '% security %'
      AND
      (
      LOWER (p.Title) like '% android %'
        OR LOWER (p.Title) like '% ios %'
      )
    )
  )

  
order by p.Id

fork query

edited nov 6

created sep 10 22 anonymous