$sql = "UPDATE artists SET page=LOAD_FILE('$infile') where code='$code';"; #### my $sth = $dbh->prepare('UPDATE artists SET page=LOAD_FILE(?) WHERE code=?'); for my $code ( keys %hash ) { $sth->execute( $hash{$code}, $code ); }