I hope this is the place for my my question:
I work on a file tagging system. I write it in java and use MySQL as my DB.
I have a table that contain only one field: file's path.
when directory is renamed, it's path changes. and that's mean, that all the files in the system, which are in the directory (or in its sub-directories), have false path.
in such case, I want to update all the files which start with the changed directory path.
but the update should be replacing the beginning of all thus paths, with the new beginning (to replace the old directory name in the new, but in the middle of another paths).
how could I do that? how could I make it the most efficient?