I have a client who wants a ranked search using php/mysql. Most of the fields being searched are lacking in much text content ie yes/no, male/female etc, so we want to rank the results by how many columns in the table matched the columns searched in the query. Is this possible? If so, how?

Thanks in advance

Lucas Young