5

Please login or register to vote for this query.

(click on this box to dismiss)

Updated with feedback from CodeReview.SE: https://codereview.stackexchange.com/q/176680

Q&A about the site for administrators, end users, developers and designers for ExpressionEngine® CMS

SELECT Id AS [Post Link]
FROM Posts
WHERE
--PostTypeId = 1 AND
ClosedDate IS NULL AND
(
  Body LIKE '%<p>[abcdefghijklmnopqrstuvwxyz]%' OR
  Title LIKE '[abcdefghijklmnopqrstuvwxyz]%' OR
  Title NOT LIKE '%?'
  COLLATE Latin1_General_CS_AS
)
ORDER BY Id ASC

view current version

edited nov 11 16

created nov 6 16 Gao