Windows 10 reached EOS (end of support) on October 14, 2025. If you are on Windows 10, see this article.

Avatar for Username

Search Support

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

Learn More
Echekwara usoro a. Biko jụọ ajụjụ ọhụrụ ma ọ bụrụ na ị chọrọ enyemaka.
Echekwara

How to search and filter history in sqlite3?

Firefox Ndekọ
TyDraniu replied
ab2qik
ab2qik

How to search and filter history on specific values like url, title, date/time visited in sqlite3?

Thankyou ab2qik.

How to search and filter history on specific values like url, title, date/time visited in sqlite3? Thankyou ab2qik.

All Replies (1)

TyDraniu
TyDraniu
  • Top 10 Contributor

You can use this kind of select: 

SELECT datetime(h.visit_date/1000000,'unixepoch'), p.url, p.title
FROM moz_places p, moz_historyvisits h 
WHERE p.id = h.place_id