🚀 go-pugleaf

If you have a table which contains info on people. For Example:

PersonTable (Table Name)
Name, Hair_Color and  Eye_Color (Fields)

How would I write a SELECT query to search for people whos name is "TED" has
"BROWN" hair and "GREEN" eyes? I want to return records sorted by bestmatch.
ie. Records that contain all three of the search criteria, then records that
contain "TED" and "BROWN" hair, then records that contain "TED"
and "GREEN" eyes, and so on.

AND searches would simply omit records that didn't contain all three and an
OR search would return all records with any of the criteria, but not in
order of relevance.
I asked this question once before here, but no-one had a detail answer. I
know what needs to be done, just not how to word it in SQL.

-Derek