MySQL Query - Order by best matches
I'm certainly no mySQL guru so i'm looking for some assistance with a query. The query below brings back 1 exact match fine but the data in the table is not fully complete. What I want to do is return the all results in order of 'all 5 match', '4 match', '3 match', '2 match', '1 match'.
SELECT * FROM master WHERE
I hope I've explained it ok! Any help would be appreciated. Thx in advance.