Compare tables, display similar ones

A

Anonymous

Guest
This question is going to be tough, I know that already. Here it goes though:

I have a table, and each row in that table has 4 columns (one, two, three, and ID). What I want to do, is compare all the rows in this table, and display the 5 rows that are the most similar (possibly with a percentage of how similar they are?). Please help me, or let me know if you need more detail. Thanks so much

:help:
 
Most similar to the one I pull up.

I have a table 'lists' with the rows 'one' 'two' 'three' and 'ID'. I'll be calling a list by the ID. What I want to do, is compare all the rows in this table 'lists', and show the 5 that are the most similar by comparison to the one that's been called.
 
You must log in or register to reply here.
Back
Top