Basically what I'm trying to ask is, for instance if my data is like this
index, field1, field2
1, apple, boy
2, apple, girl
3, boy, apple
4, boy, girl
5, girl, apple
How do i format my query to give me a results that says:
1 matches with 3
2 matches with 5
3 matches with 1 (optional but good to have)
5 matches with 2 (optional but good to have)
Thanks for your help.
... View more