[GENERAL] Deadlock with single update statement?

Hi,

I’m trying to track down a deadlock happening in a live app. I’m wondering about statements like this, which select
morethan one row to update: 

     update t set num = 1 where name = ‘foo’;

It appears to be causing a deadlock, but I can’t reproduce it on my test database. Could two threads, each running this
update,get in a deadlock? In other words, are both of the following true: 

1. The update locks each row in sequence, not all at once.
2. The order of the row locking could vary from one thread to the next.

thanks,
Rob