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.