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 = AND = AND = k.place_id
WHERE LOWER(ia.content) LIKE '%searchstr%'
  OR LOWER(k.keyword) LIKE '%searchstr%'
GROUP BY b.title, p.url, ia.content