mass updating mysql

[Lionel]

What would be the easiest way to update a table column where all values are not the same

I have all avatars as "images/avatar/avname.jpg"
and I simply want to change the path to "/forums/images/avatar/avname.jpg"

or let me rephrase it. How would I go about adding a prefix to all values in that column like:

/forums/

[nico_swd]

vB?

PHP Code:

$query = $db->query("SELECT * FROM ". TABLE_PREFIX ."avatar");

while ($avatar = $db->fetch_array($query))
{
    $db->query("
          UPDATE ". TABLE_PREFIX ."avatar
          SET avatarpath = '/forums/". $avatar['avatarpath']."'
          WHERE avatarid = ". $avatar['avatarid']
    );
} 


Untested but should work.

I don't think this is a good idea though. Don't you think that this might causes problems in the forum?

[Lionel]

thank you. What problems are you anticipating?

[nico_swd]

Well the forum software (being installed in /forum/) would pull the images from /images/avatar/. Now that you change the path, it would attempt to get the images from /forum/forum/images/avatar/. And that would probably fail.

EDIT:

Nevermind. If you put the slash at the beginning of the path it should work.