I have a table setup as follows:
userid year model color transmission interiorcolor wheels ------------------------------------------------------------------- 1 2005 Fiesta Red MT Black Stock 2 2008 Monaro Red AT Black Stock 3 2005 F-150S Blue AT Black + Red Stock 4 2008 Fiesta Green MT Black Stock
Now I am building an SQL search (no standard build in full text search), and I want to results to be somewhat relevant.
What i mean is that for example if someone types in "2008 Fiesta", right now with a basic query the results come out in this order
id #1, id #2, id #4
But really I would like #4 to be on the top of the search in that case because it matches my search on two fields instead of just one field.
Thank you!