Search issues

[matfish]

Hi, The problem Iv got is that when searching the site - it brings back different results or sometimes no results.

For example: "i026", "i 026" and "026" do not bring back results for "I-026" which is the correct model number. Any ideas on how to make it search more variations or of a "Did you mean... I-026" script?

 

Currently does a:

SELECT * FROM table WHERE model_no="%I-026%"

 

Many thanks