Compare two fields in Mysql

To compare the content of two fields in mysql and print the matching results do the following:

select * from user where username=password;

This would match all users that have the same username and password