On 10 Oct, 12:44, UKuser <spiderc...@yahoo.co.uk> wrote:
> Hi,
>
> I'm having fun with my queries and I can't seem to find the solution.
Surely you don't want to. If you find a solution the fun will stop and
that's no fun at all!


> Lets say I have some data in a 2 column table:
You have some data in a 2 column table. There, I've said it.
>
> 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.
True

> b) If I use LIKE - thats a lot of unindexed rows to get through.
Why? Since all of the words that you are interested in start with
"Apple", just build an index on the NAME column and then there are no
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.
See answer to (b) above.

> So whats the solution?
See answer to (b) above