Sql command to change email domains
 

I'm looking for a sql querie/command to do the following.

We got a lot of users using an email adress ending with @domain.com and those need all to be changed to @otherdomain.com.
I think the best way to do this is via a mysql query.

But I don't know mysql, so can somebody give me the correct query statement?