On 10 Oct, 13:11, Captain Paralytic <paul_laut...@yahoo.com> wrote:
> 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

Not greatly helpful .....