To filtering by a specific date, we just add. select DISTINCT REPLACE(urls.title, " - Google Search", "") Here’s the query we had from before, for accessing our Google Search history. cp ~/Library/Application\ Support/Google/Chrome/Default/History ~/my-history To run these queries, first make a copy of your browser history and open it in sqlite3. Google Chrome selects a slightly non-standard time storage format (microseconds since JanuUTC), hence the need for this query stanza. In this snippet, I show how to amend them to filter the results by date. Number of SQL queries for browsing my browsing history.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |