Hello Karl, Try the 'FULLTEXT' section of the manual. I've used the fulltext index to create a search engine for a mailing list archive, and I'm quite pleased with how it works.
http://www.mysql.com/doc/F/u/Fulltext_Search.html /Rob "Karl J. Stubsjoen" wrote: > Hello, > > I need to create a search engine out of a few MySQL tables.... I should > say: I need to search MySQL records like a search engin might. However, my > first go ended up as a complete failure because it is highly un-optimized to > search for (as an example) %apple% in all of the available text fields. > > Any ideas about where I can look to set up a database optimized for > searching in this way? -- Robert Alexander, Alpha Geek, Workmate.ca WWW Database Applications and Web Hosting http://www.workmate.ca 416-823-6599 mailto:[EMAIL PROTECTED] "Life's unfair - but root password helps!" --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php