Article title grep backend replacement

SQL

/* A backend replacement for https://tools.wmflabs.org/grep/ 
The current implementation of grep is very slow.
*/
SET @regex_pattern = "^U\+";
SET @like_pattern = "U+%";

USE enwiki_p; /* "Language" and "Project" */
SELECT *
FROM page
WHERE 
  page_namespace = 0 /* Namespace */
  /* AND page_title REGEXP @regex_pattern /* "Pattern" */
  AND page_title LIKE @like_pattern /* More straightforward option for pattern-based searching */  
  /* AND NOT page_is_redirect - negate "Include redirects" */
LIMIT 1000 /* "Limit the display to the first 100 results" */

SQL

Checking query status...