you *could* go with if-statements, returning a numerical weight for each criterion if match and 0 if not; summing those and sorting by the sum column.
I would do it in code, though - it may or may not be less efficient, but it'll be easier to maintain and read. On Tue, May 12, 2009 at 5:50 PM, blackwater dev <blackwater...@gmail.com>wrote: > I have a hold car data such as color, model, make, year, etc. I want to > allow the user to answer some questions and I'll present them with the car > that 'best' matches their criteria. How do I do this? I still want to > return ones that don't match exactly but want the closer matches ordered at > the top: > > Table:cars > > columns: car_id, make, model, year, color, condition > > So if the user enterrs: > > model: Toyota > year: 1998 > condition:great > color: blue > > I would show them a blue 1998 good conditioned camry first but farther down > in the list might still have a blue good condition 98 Honda. > > Thanks! > -- Celsius is based on water temperature. Fahrenheit is based on alcohol temperature. Ergo, Fahrenheit is better than Celsius. QED.