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 |