USE enwiki_p;
SELECT * FROM page
where page_title = "afghanistan%"
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM page
where page_title like "afghanistan%"
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM page
where page_title like 'afghanistan%'
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM page
where page_title like 'bmw%'
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM page
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM pages
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM templatelinks
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM category
order by cat_pages desc
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM category
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM page
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM page
--where page_title = 'BMW 3 Series (E21)'
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM page
where page_title = 'BMW 3 Series (E21)'
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM page
where page_name = "BMW 3 Series (E21)"
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM page
where page_name = "BMW 3 Series (E21)"
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM page
where page_title = "BMW 3 Series (E21)"
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM page
where page_title = "bmw%"
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM page
where page_title like "bmw%"
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM page
where page_title like 'bmw%'
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM page
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT * FROM image wi
LIMIT 10 |
5 years ago |
USE enwiki_p;
SELECT top10 * FROM image wi |
5 years ago |
USE enwiki_p;
SELECT top 10 * FROM image wi |
5 years ago |
USE enwiki_p;
SELECT * FROM image wi |
5 years ago |
USE enwiki_p;
SELECT wp.page_id FROM image wi |
5 years ago |
USE enwiki_p;
SELECT wp.page_id, CONCAT("File:",wp.page_title) as... |
5 years ago |
use wikidatawiki_p;
select * from wb_page |
5 years ago |