How to manually modify a group of firefox history links, preferably by some text editor

This question refers to FireFox v25 in my case.

A Wiki Workspace used by me, changed its name from

https://wikis.mycompany.com/teamcollab/wiki/MyProduct+Alpha+QA:Test+Automation

to

https://wikis.mycompany.com/teamcollab/wiki/MyProduct+QA:Test+Automation

omitting the word "Alpha" from the Wiki's name and URL.

I am frequently returning to pages on the wiki, by starting to write sections of the page's URL or Title in the address bar, which auto-suggests me relevant pages.

Now, this feature is broken, as all my pages are leading to the wrong URL and as a bonus, I now have duplicates of the new wiki and the old wiki in the history.

Since the History is saved in the

I want to be able to do the following (which is available for Bookmarks)

1) Export all the History I have 2) Manually go into the History and replace the URL and Title contents. 3) Import the new History.

or alternatively, what is a proper sqlite sql query to change the history.

I looked for a suitable Firefox add-on, but couldn't find one so far. This can also be a good option.

Thanks.

RaamEE

------IMPORTANT------

Save a copy of places.sqlite before you begin. Save 2 copies if needed. Use at your own discretion

------IMPORTANT------

I chose the dirtiest quickest solution. running 400 SQLite UPDATE commands to change 400 records.

1) copy a backup of places.sqlite from /Users/YourUserName/Library/Application Support/Firefox/Profiles/7skm4kzn.default/places.sqlite (MacOS system. The last directory differs between profiles) to places_bak.sqlite

2) run a HERE script to select the records and output into file

#!/bin/bash

sqlite3 places.sqlite << HERE > results.sql
        select id, url from moz_places where url like '%MyProduct+Alpha+QA%';
HERE

3) Use vi and the next substitution to modify the urls (I didn't need to touch the Title)

:%s/\([0-9]*\)|\(.*\)MyProduct+Alpha+QA\(.*\)/UPDATE moz_places SET url='\2MyProduct+QA\3' WHERE id=\1;/gc

This will remove the word "+Alpha" from the URL and create a new set of UPDATE commands which in turn you can dump into the DB file using this HERE script

#!/bin/bash

sqlite3 places.sqlite << HERE
        `cat results.sql`
HERE

4) Copy & Replace the original places.sqlite under your profile path. I suggest you shutdown firefox before overwriting the original file.