UPDATE files SET filepath = REPLACE(filepath,'path/to/search','path/to/replace');