Welcome Guest, Not a member yet? Register   Sign In
Close Matches SQL

I have a search function that pulls data from a database, with quite a few WHERE clauses already. However, I would like to show the user close matches as well, meaning results that don't meet all the conditions, but only a set of core-conditions and as many of the others as possible, sorted by how many are met.

Does it make sense to get the result-set that meets all of the core-conditions and do the rest of the filtering through php—manipulating a possibly very large dataset—or is there a way to do this natively through the query?

Messages In This Thread
Close Matches SQL - by El Forum - 02-20-2010, 08:33 AM
Close Matches SQL - by El Forum - 02-22-2010, 02:25 AM

Theme © iAndrew 2016 - Forum software by © MyBB