I'm fairly new to mysql and I have no idea if I'm heading in the right direction but I'm having trouble with a mysql query.

I basically have a table of users

id      name  
----    -------- 
1       user1          
2       user2          
3       user3          
4       user4

as well as a table of user attributes

id      userid   attribute 
----    -----    ------ 
1       1        5          
2       1        6       
3       2        5          
4       3        4

I want to be able to select users that have both the attribute 5 and the attribute 6, so in this case I want to return

id      name  
----    -------- 
1       user1  

I tried using a join like this.

SELECT u.id, u.name FROM users u LEFT JOIN attributes a ON (a.userid = u.id) WHERE a.attribute = 5 AND a.attribute = 6

But obviously that won't work, what is the best way of doing this?