Batch adding prefix/suffix to post titles by category

Hi there,

my blog now has about 1000+ posts, so it would take forever and a day to do this manually.

My site is a magazine where you can find book reviews, music reviews, film reviews, columns, interviews and more. To give the post titles a better expression, i’d like to add a prefix or a suffix to the existing post titles, and every category needs a different pre- or suffix.

Example:

In every post of the category “bookreviews” I’d like to change

This is the author’s name – This is the book title
This is another author’s name – This is the book title of another book

to

This is the author’s name – This is the book title [book review]
This is another author’s name – This is the book title of another book [book review]

(as you see, it is just adding a suffix)

…while I’d like to add a the suffix “[music review]” to existing titles which posts are categorized in “musicreviews”

Name of the band – Title of the album
Name of another band – Title of the album (2CD)

to

Name of the band – Title of the album [music review]
Name of another band – Title of the album (2CD) [music review]

I hope you understand.

My coding knowledge is not that good, so I don’t really know how to realize it. So is there a plugin, a code or are there sql commands which can do what I would like to do?

Any hel (or link to a solution) is highly appreciated.