Add-ons

Search bookmarks by description or keywords

Query the bookmarks SQLite database, file places.sqlite in the browser profile directory

SELECT b.title 'Title', p.url 'Location', ia.content 'Description'
FROM moz_items_annos ia
  INNER JOIN moz_bookmarks b
  INNER JOIN moz_places p
  INNER JOIN moz_keywords k
ON ia.item_id = b.id AND p.id = b.fk AND p.id = k.place_id
WHERE LOWER(ia.content) LIKE '%searchstr%'
  OR LOWER(k.keyword) LIKE '%searchstr%'
GROUP BY b.title, p.url, ia.content