Query Run
USE zhwikibooks_p; SELECT page_namespace, page_title FROM page LEFT JOIN... 7 years ago
USE zhwiki_p; SELECT page_namespace, page_title FROM page LEFT JOIN user ON ... 7 years ago
USE zhwikibooks_p; SELECT page_namespace, page_title FROM page LEFT JOIN... 7 years ago
USE zhwikibooks_p; SELECT page_namespace, page_title FROM page LEFT JOIN... 7 years ago
blank query 7 years ago
USE zhwiki_p; SELECT page_namespace, page_title FROM page LEFT JOIN user ON ... 7 years ago
USE zhwiki_p; SET @ip_regex =... 7 years ago
SET @a = 'Example/test'; SELECT IF(INSTR(@a, '/'), MID(@a, 1, INSTR(@a, '/')-1), @a) 7 years ago
SET a = 'Example/test'; SELECT IF(INSTR(a, '/'), MID(a, 1, INSTR(a, '/')-1), a) 7 years ago
SELECT MID('Example/test', 1, INSTR('Example/test', '/')) 7 years ago
SELECT INSTR('User:Example/test', '/') 7 years ago
SELECT INSTR('User:Example/test', '/') OR 1 7 years ago
SELECT 0 OR 1 7 years ago