Mass edit rows in phpmyadmin

Hey guys. I run a subtitle host and recently i had to change the location of the stored files. Problem is now that i have 300+ rows in phpmyadmin where "subs/" must be removed from "filename". is there an easy way to do this?

Regards

 

UPDATE my_table SET my_column_i_need_to_fix = REPLACE(my_column_i_need_to_fix, 'subs/', '');

Make sure to do a backup of the table before running in case anything gets messed up.

 

hey jestep, thanks for your reply. i will try this after making a backup.

backup done. just to be clear the command should look like this:
UPDATE subs SET filename = REPLACE(filename, 'subs/', '');

correct?

 

it worked perfectly, thank you jestep!