Hi,

I'm having fun with my queries and I can't seem to find the solution.

Lets say I have some data in a 2 column table:

ID--NAME
1--Appledown
2--Applewear
3--Applesmith
4--Applehear

Lets say theres 9000 of those rows. What would be the best way of
doing a search, where the given search phrase is apple?

a) If I do a fulltext index on the field it won't find anything using
Match.
b) If I use LIKE - thats a lot of unindexed rows to get through.
c) If I create a php method to look in a cached version, 9000 rows
equals 1/2 meg as a csv file.

So whats the solution? Type build into google and it will find
building, so there is obviously ways to get round it, but I'm
interested to know how people resolve this searching issue.

Thanks

A