searching

[robsgaming]

I've looked around and could not find the answer I was looking for so I'm resorting to the boards...

I run a gaming site. Currently, I have an area for users to search for a game by the game title. However, if they misspell it or don't type part of it or all of it exactly the way it's in the database, nothign will be returned.

All I'm using is the like command in the query:

SELECT * FROM tablename WHERE gametitle LIKE '%$querystring%'

Is there another query I could run that will try to match spelling and such... example:

Let's say a user types in 'marrio' instead of 'mario'. Can I have it say something like 'no direct result was found, but here are similar matches' or something like that?

Thanks in advance for any help.

[crowezr]

I sure there are better ways, but maybe this will spark something from someone else. If no results are found, you could maybe divide their string into smaller substrings and try to match these against your database. Obviously, the potential to come up with less relevant results may be there, but if you divided it into fairly large chunks, you may get decent results.

[robsgaming]

good idea... maybe if it doesn't find anything with the first query, it will search the first 3 letters or something...