Update records without looping

In order to update multiple records, I first need to query, loop through the list, then update one record at a time. I find this to be extremely slow.

Is there a way to update records directly, like something you can perform in SQL like
update user set firstname = 'John' where lastname = 'Smith'