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