<?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); } ?>]]>