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