| select page_title
from page
where
page_namespace = 0 and page_is_redirect... |
3 years ago |
| select page_title , page_title REGEXP '[^_]'
from page ... |
3 years ago |
| select page_title REGEXP '[^_]'
from page
where
page_namespace = 0 and... |
3 years ago |
| select page_title REGEXP '([^_]\()'
from page
where
page_namespace = 0 and... |
3 years ago |
| select page_title REGEXP '([^_]\('
from page
where
page_namespace = 0 and... |
3 years ago |
| select page_title
from page
where
page_namespace = 0 and page_is_redirect... |
3 years ago |
| select *
from page
where
page_namespace = 0 and page_is_redirect = 0 and... |
3 years ago |
| select *
from page
where
page_namespace = 0 and page_is_redirect = 0 and... |
3 years ago |
| select *
from page
where
page_namespace = 0 and page_is_redirect = 0 and... |
3 years ago |
| select *
from page
where
page_namespace = 0 and page_is_redirect = 0 and... |
3 years ago |
| select *
from page
where
page_namespace = 0 and page_is_redirect = 0 and... |
3 years ago |
| select *
from page
where
page_namespace = 0 and page_is_redirect = 0 and... |
3 years ago |
| select *
from page
where
page_namespace = 0 and page_is_redirect = 0 and... |
3 years ago |
| select *
from page
where
page_namespace = 0 and page_is_redirect = 0 and... |
3 years ago |
| select *
from page
where
page_namespace = 0 and page_is_redirect = 0 and... |
3 years ago |
| select *
from page
where
page_namespace = 0 and page_is_redirect = 0 and... |
3 years ago |
| select *
from page
where
page_namespace = 0 and page_is_redirect = 0 and... |
3 years ago |
| select *
from page
where
page_namespace = 0 and page_is_redirect = 0 and... |
3 years ago |
| select *
from page
where
page_namespace = 0 and page_is_redirect = 0
limit 10; |
3 years ago |
| select * from page where page_namespace = 0 limit 10; |
3 years ago |
| select * from page where page.page_namespace = 0 limit 10; |
3 years ago |
| select * from page limit 10 where page.page_namespace = 0; |
3 years ago |
| select * from page limit 10 where page_namespace = '0'; |
3 years ago |
| select * from page limit 10 where page_namespace = 0; |
3 years ago |
| select * from page limit 10; |
3 years ago |
| select * from page_title limit 10; |
3 years ago |
| select * from comment limit 10; |
3 years ago |
| select * from comment; |
3 years ago |
| desc comment; |
3 years ago |
| show tables; |
3 years ago |
| select *
from watchlist
limit 10; |
3 years ago |
| select *
from watchlist
limit 10; |
3 years ago |
| select *
from recentchanges
limit 10; |
3 years ago |
| select *
from sites
limit 10; |
3 years ago |
| select *
from page
where page_is_new != 0
limit 10; |
3 years ago |
| select *
from page
where page_is_new !== 0
limit 10; |
3 years ago |
| select *
from page
limit 10; |
3 years ago |
| select *
from user
ORDER BY user_editcount DESC
where user_name like... |
3 years ago |
| select *
from user
ORDER BY user_editcount DESC
where user_name not like... |
3 years ago |
| select *
from user
ORDER BY user_editcount DESC
where user_name not... |
3 years ago |
| select * from user ORDER BY user_editcount DESC limit 10; |
3 years ago |
| select * from user ORDER BY user_editcount limit 10; |
3 years ago |
| select * from user where user_name like %a% limit 10; |
3 years ago |
| select * from user where user_name like %a% limit 10; |
3 years ago |
| select * from user where user_name = %a% limit 10; |
3 years ago |
| select * from user where user_name %a% limit 10; |
3 years ago |
| select * from user limit 10; |
3 years ago |
| select * from user limit 100; |
3 years ago |
| select * from user limit 10; |
3 years ago |
