Drupal 6 db_query files table

As part of moving from a windows server to a linux server I have to clean up a large number of filenames.

My Problem is that when I execute:

db_query("UPDATE {files} SET filename = '%s' AND filepath =开发者_StackOverflow社区 '%s' WHERE fid = %d", $file->filename, $file->filepath, $file->fid);

and afterwards select the content for $file->fid the filename field has the value of "0"

If I dump the query as text both before and after it's being executed the filename field contains the filename I have specified where as the filepath is being stored correctly.

DAMN! putting an AND into an update query will not produce the expected result... MySQL allows this but it's not the way to go :)

Use a comma instead of AND.

Might also want to look into using drupal_write_record() instead of db_query. drupal_write_record will automatically update a pre-existing row if you add the 3rd parameter for a key to check. In your case, you could use the file id.