Fork of
Article title grep backend replacement
by Retro
This query is marked as a draft
This query has been published
by Retro.
SQL
x
SET @regex_pattern = "^WP";
SET @like_pattern = "WP%";
USE enwiki_p;
SELECT page_title
FROM page
WHERE
page_namespace = 10
AND page_title LIKE "WP%"
AND page_is_redirect = 0
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.