MySQL UPDATE query with two WHERE caluses not working? : I have the following query that isnt working for some reason:

    UPDATE accounts 
    SET displayname = 'test', member = '5'
    WHERE username = 'testuser' AND password = 'testpass';

However, this works fine:

    UPDATE accounts 
    SET displayname = 'test', member = '5'
    WHERE username = 'testuser';

How do I update based on two where clauses?