"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?
Read the manual and list threads on fulltext indexes. b. mysql --------------------------------------------------------------------- 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