/* 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 100 /* "Limit the display to the first 100 results" */