how to update part of the string in table

[jansky]

To all guru

how can i update part / word of a string in my table

tablepath
id | main_ID | rootfolder

1 | 3 | http://www.myurl.com/category/Agriculture/Fishery/

2 | 3 | http://www.myurl.com/category/Agriculture/Marine_life/

I only want to update /Agriculture/ into /New_Agriculture/
so the new update will be

tablepath
id | main_ID | rootfolder

1 | 3 | http://www.myurl.com/category/New_Agriculture/Fishery/

2 | 3 | http://www.myurl.com/category/New_Agriculture/Marine_life/

[devinemke]

a simple example (assuming mySQL):

<?php
// connect to db

$result = mysql_query("SELECT id, rootfolder FROM tablepath WHERE rootfolder LIKE '%Agriculture%'") or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
	$rootfolder = str_replace('Agriculture', 'New_Agriculture', $row['rootfolder']);
	$result_update = mysql_query("UPDATE tablepath SET rootfolder = '$rootfolder' WHERE id = " . $row['id']) or exit(mysql_error());
	echo 'row '  .$row['id'] . ' updated<br>';
}
?>