Author: BRENT Email: [EMAIL PROTECTED] Message: I need to index the fields of an existing MySQL table. (I'm not scanning websites). The table will have about 1 million rows in it and I need fast text retrieval, something like MySQL's FullText index. So the user will enter one or more words, and it should return the records sorted by the highest ranking records first.
Before downloading & installing MnoGoSearch I have a few questions that I need answered to make sure it will do what I think it will do. 1) Can MnoGoSearch index an InnoDb table? (MySQL table with Type=InnoDb) 2) Does MnoGoSearch work with MySQL 4? 3) To index the fields of a table, do I have to put all of the fields I want to index in the one table? Or can I have a secondary table that is linked by a foreign key? Example: Table1: Employees Fields: Employee_Id, Employee_Name, Dept, Boss, HireDate FK: Addr_Id Table2: Addresses Fields: Addr_Id, Street, City, Country, Phone FK: Employee_ID, So if the search has the person's address "123 Park Street" I'd like it to return info from both tables like Employee_Name, Dept, Phone etc. Can MnoGoSearch do this? Or does all of the data have to be in the one table? TIA Brent Reply: <http://www.mnogosearch.org/board/message.php?id=3684> ___________________________________________ If you want to unsubscribe send "unsubscribe general" to [EMAIL PROTECTED]
