I'm building a financial-like web site (PHP - MySQL). I was requested to build a search engine for IT.
Everything works OK, w/ the exception of a certain component. The owner of the web site will write, each day, a report for the customers. I use TEXT fields to record each section of the report (there are 4 sections). Now the search part: 1. I can use LIKE %keyword% but when the DB will grow, I guess I will get into trouble. 2. I can use MATCH - AGAINST, but the report it's quite stereotypical: most of the words a user will look for are very common (the 50% rule). Any suggestion ? -- Cip -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]