------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.