How to remove large number of entries from url history in Firefox?

How to remove large number of entries from url history in Firefox? I want to remove large number of urls from my page history - they all match simple regexp, but there is a lot of them - doing this by "delete" in suggestion box is not an option. And when I bring history tab, whenever I click on item, it automatically opens - so I can't remove there anyway.
Asked by: Guest \| Views: 355

Total answers/comments: 2

Comments display order:

bert [Entry]

"Seems you are right. In my Firefox profile directory, there is a filed named places.sqlite. Opening it with sqlite reveals (amongst others) the tables moz_places and moz_historyvisits. It seems that moz_historyvisits uses the primary of moz_places to refer to the URLs.

I suggest you back up that file before you start deleting."

bert [Entry]

"They are stored in the moz_places table as full URL strings in the places.sqlite database, which is found in these locations:

Windows XP

C:\Documents and
Settings\[username]\Application
Data\Mozilla\Firefox\Profiles\[profile
folder]\places.sqlite

Windows Vista

C:\Users\[user]\AppData\Roaming\Mozilla\Firefox\Profiles\[profile
folder]\places.sqlite

GNU/Linux

/home/[user]/.mozilla/firefox/[profile
folder]/places.sqlite

Mac OS X

/Users/[user]/Library/Application
Support/Firefox/Profiles/default.lov/places.sqlite

of course, [user] and [profile folder] will be different for your machine."