Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Justinzobel/7b1f641f3b1ce34fb4c8c727ae506933 to your computer and use it in GitHub Desktop.
Save Justinzobel/7b1f641f3b1ce34fb4c8c727ae506933 to your computer and use it in GitHub Desktop.
MySQL command to get a list of all pages (decoded from binary) and show the date they were last modified (in YYYYMMDD etc)
select cast(page_title as CHAR),cast(page_touched as CHAR) from page ORDER BY page_touched ASC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment