Feature req: update when the index field is not the primary key

[swedge218]

Sometimes, the field to update will not be indexed by the primary key. Being able to specify the field e.g. in a where clause will be good.