/* A backend replacement for https://tools.wmflabs.org/grep/ 

The current implementation of grep is very slow.

*/

SET @regex_pattern = "^U\+";

​

USE enwiki_p; /* "Language" and "Project" */

SELECT *

FROM page

WHERE 

  page_namespace = 0

  AND page_title REGEXP @regex_pattern /*  */

  /* AND NOT page_is_redirect - negate "Include redirects" */

  /* page_title LIKE "%(%)%" - More straightforward option for pattern-based searching */

/* LIMIT 100 - "Limit the display to the first 100 results" */