What is the MOST appropriate way to update the email address for a user named 'John Doe' in a database, knowing that there may be multiple users with that name, but each user has a unique identifier (UserID)?
Use an UPDATE statement that changes the email address where the user's first name is 'John' and the last name is 'Doe'.
Use an UPDATE statement with the correct email address where the UserName is 'jdoe'.
Issue a SELECT command to find all users named 'John Doe' and update the email address individually for each record returned.
Use an UPDATE statement to change the email address where the UserID matches John Doe's unique identifier.