CodingForums.com - View Single Post - Getting the nearest SQL results if a query cannot find an exact match?

LiamHorizon · 10-10-2012, 01:25 PM

Thanks for your reply

Okay I will look at the % and remove what is needed.

I understand what you mean; having the results being able to find the closest match to the users input is what I am looking for.

So. If a user searched for w"120" l"170" d"90", I would want the search to be able to find any records that can either match or be closest too by a certain amount, say "20". So if there was a record with a width of "120" then it would definitely display that record. If there was no record with a length of "170" then a result within a "20" range would be found and added to the results.

Does this make sense? Sorry haha.

EDIT: sorry forgot to answer you query

Ultimately any of those queries should be displayed. Due to the fact that they are all within 20 of the user input and some are exact matches. But they wouldn't duplicate hopefully.

10-10-2012, 01:25 PM	PM User \| #3
LiamHorizon New to the CF scene Join Date: Oct 2012 Posts: 6 Thanks: 0 Thanked 0 Times in 0 Posts	Thanks for your reply Okay I will look at the % and remove what is needed. I understand what you mean; having the results being able to find the closest match to the users input is what I am looking for. So. If a user searched for w"120" l"170" d"90", I would want the search to be able to find any records that can either match or be closest too by a certain amount, say "20". So if there was a record with a width of "120" then it would definitely display that record. If there was no record with a length of "170" then a result within a "20" range would be found and added to the results. Does this make sense? Sorry haha. EDIT: sorry forgot to answer you query Ultimately any of those queries should be displayed. Due to the fact that they are all within 20 of the user input and some are exact matches. But they wouldn't duplicate hopefully. Last edited by LiamHorizon; 10-10-2012 at 01:29 PM..