select page_id, page_title from page where page_title = 'Smart_system' limit 5; |
5 years ago |
select page_id, page_title from page where page_title like 'Smart_system' limit 5; |
5 years ago |
select page_id, page_title from page where page_title like 'Smart%' limit 5; |
5 years ago |
select page_id, page_title from page where page_title like '%smart%' limit 5; |
5 years ago |
select count(*) from page where page_title like '%smart%'; |
5 years ago |
select count(*) from page where title like '%smart%'; |
5 years ago |
select count(*) from Pages.page where title like '%smart%'; |
5 years ago |
select count(*) from Pages.page; |
5 years ago |
SHOW TABLES FROM enwiki_p; |
5 years ago |