[Mediawiki-l] Articles containing a string?

[Daniel Barrett]

Is this a correct query to find all current articles that contain a
given string?

SELECT 
  p.page_namespace
 ,p.page_title
FROM
  page p
  INNER JOIN revision r ON p.page_latest = r.rev_id
  INNER JOIN text t ON t.old_id = r.rev_text_id
WHERE
  t.old_text like '%STRING%'

Thanks,
DanB