SELECT COLUMN_NAME
WHERE TABLE_NAME = 'page'
ORDER BY ORDINAL_POSITION |
2 years ago |
SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME =... |
2 years ago |
SELECT page_creator FROM page AS author where author REGEXP 'QRep2020'; |
2 years ago |
SELECT page_title FROM page where page_title REGEXP '( |_)tesla_'; |
2 years ago |
SELECT page_title FROM page where page_title REGEXP 'tesla'; |
2 years ago |
SELECT page_title FROM page where page_title REGEXP '*tesla*'; |
2 years ago |
SELECT page_title, rev_timestamp FROM page where page_title REGEXP '*tesla*'; |
2 years ago |
SELECT page_title, rev_timestamp FROM page where page_title REGEXP '*tesla*'; |
2 years ago |
select page.page_namespace AS tesla where tesla REGEXP '*\wiki\*tesla*'; |
2 years ago |