<?php

$db = mysql_connect("localhost", "USERNAME", "PASSWORD");
mysql_select_db("DATABASENAME",$db);

$sql = "SELECT * FROM fud26_attach WHERE location LIKE '%/OLD/PATH/TO/FILES/%'";
$result = mysql_query($sql,$db);


while($row = mysql_fetch_array($result))
{
 $tmp = $row['location'];
 $tmp = str_replace('/OLD/PATH/TO/FILES/','/NEW/PATH/',$tmp);
 $sql = "UPDATE fud26_attach SET location='".$tmp."' WHERE id='".$row['id']."'";
 mysql_query($sql,$db);
}
?>