Ryan Veety wrote:
>
> I'm using mysql to search a very large database of books. I need it to
> search for any word in a particular field. Using this method of course is
> slow because it can't use the index:
>
> select * from books where title like '%search%';
>
> How do other search engines like altavista make substring searches so
> quickly? I need to be able to search a database with over a million
> records very fast. Any example code would be apreciated.
>
> Ryan
>
Try htdig.
--
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
