| SELECT *
FROM page
WHERE page_title RLIKE "\\*$"
AND page_is_redirect = 1 |
3 years ago |
| SELECT *
FROM page
WHERE page_title RLIKE "\\*{1,2}$"
AND page_is_redirect = 1 |
3 years ago |
| SELECT *
FROM page
WHERE page_title RLIKE "^.* .*\\*{1,2}$"
AND page_is_redirect = 1 |
3 years ago |
| SELECT *
FROM page
WHERE page_title RLIKE "\\*$"
AND page_is_redirect = 1 |
3 years ago |
| SELECT *
FROM page
WHERE page_title RLIKE "\*$"
AND page_is_redirect = 1 |
3 years ago |
| SELECT *
FROM page
WHERE page_title REGEXP "test"
AND page_is_redirect = 1 |
3 years ago |
| SELECT *
FROM page
WHERE page_title REGEXP "test"
AND page_is_redirect = 1 |
3 years ago |
| blank query |
3 years ago |
| SELECT *
FROM page
WHERE page_title REGEXP "42"
AND page_is_redirect = 1 |
3 years ago |
| SELECT *
FROM page
WHERE page_title REGEXP ".\*$"
AND page_is_redirect = 1 |
3 years ago |
| SELECT *
FROM page
WHERE page_title REGEXP ".+\*$"
AND page_is_redirect = 1 |
3 years ago |
| SELECT *
FROM page
WHERE page_title REGEXP "\*$"
AND page_is_redirect = 1 |
3 years ago |
| SELECT *
FROM page
WHERE page_title REGEXP ".+\*$"
AND page_is_redirect = 1 |
3 years ago |
| SELECT *
FROM page
WHERE page_title REGEXP ".*\*$"
AND page_is_redirect = 1 |
3 years ago |
| SELECT *
FROM page
WHERE page_title ~ "%*"
AND page_is_redirect = 1 |
3 years ago |
| SELECT *
FROM page
WHERE page_title ~* "%*"
AND page_is_redirect |
3 years ago |
| SELECT *
FROM page
WHERE page_title ~* "%*"
AND page_is_redirect == 1 |
3 years ago |
| SELECT *
FROM page
WHERE page_title ~* "%*"
AND page_is_redirect = 1 |
3 years ago |
| SELECT *
FROM page
WHERE page_title ~* "%*"
AND page_is_redirect is 1 |
3 years ago |
