SELECT `page_title` FROM
`page`
INNER JOIN `categorylinks` ON... |
2 years ago |
SELECT * FROM
page
INNER JOIN categorylinks ON... |
2 years ago |
SELECT * FROM categorylinks WHERE categorylinks.cl_to... |
2 years ago |
SELECT * FROM categorylinks WHERE categorylinks.cl_to IN('Countries by... |
2 years ago |
SELECT * FROM
page
INNER JOIN categorylinks ON... |
2 years ago |
SELECT * FROM
page
INNER JOIN categorylinks ON... |
2 years ago |
select * from categorylinks limit 10;
select * from page where page_id=2; |
2 years ago |
select * from categorylinks limit 10;
select * from category where cat_id=2; |
2 years ago |
select * from categorylinks limit 10; |
2 years ago |
describe categorylinks; |
2 years ago |
show tables |
2 years ago |
describe cat_link; |
2 years ago |
describe category; |
2 years ago |
SELECT * from page WHERE `page_title` = 'Red_number_4' |
2 years ago |
SELECT * from page WHERE `page_title` = 'Red_number_40' |
2 years ago |
SELECT * from page WHERE `page_title` = 'Category:Red_number_40' |
2 years ago |
SELECT * from category WHERE `cat_title` RLIKE '^Number_[[:digit:]]+_on_'; |
2 years ago |
SELECT * from category WHERE `cat_title` RLIKE 'Number_[[:digit:]]+_on_.*'; |
2 years ago |
SELECT * from category WHERE `cat_title` LIKE 'Number[_]%[_]on[_]%'; |
2 years ago |