I want to add a new column to the category table and then copy corresponding category names in to that column as follows, how to do this with mysqlman or some other way:

1) If my category is for example, Main/Sub1/Sub2 then I want the row in the column to show "Sub2"
2) Taking this one step further, if possible I want to add a suffix to the end of each then category like so "Sub2-Sometext" ie. it will add Sometext to the end of each category that I copied into in the new column.

Thanks!