I need to find best matches from a mysql table given a set of attributes.

I need to find best matches from a mysql table given a set of attributes.

For example, given ATTRIBUTE1, ATTRIBUTE2 and ATTRIBUTE3, I want to get the results as follows:

rows with all attributes matched
rows with 2 attributes matched
rows with 1 attribute matched
so far I only know how to accomplish the first statement:

SELECT * FROM Users
WHERE ATTRIBUTE1="aValue", ATTRIBUTE2="aValue", ATTRIBUTE3="aValue"
LIMIT 20

N.B. I need 2 lists. A list with fully matching rows and a list with partial matches