kwstephenchan Posted November 10, 2006 Share Posted November 10, 2006 Hi everyone, I am new to MySql' full text search. I have gone through the tutorial and full text search topics in this forum but found not much specific to my questions here, hope that someone could give me some hints here regarding the following, thanks!1. the full text index, is it created in advance or the script for creating the full text index is done along with the query script2. do I need to create full text index on multiple table if I want to search multiple table, and how do I link them together3. from the forum, someone mentioned that full text search is for English only and not much use for other languages, is that true??Stephen Quote Link to comment Share on other sites More sharing options...
fenway Posted November 10, 2006 Share Posted November 10, 2006 1. You'd have to make the FULLTEXT index cover whatever columns you want to be searched.2. You'd need one for each table, and join the matches accordingly.3. The current implementation is designed for normal flowing english text only, and it's rather inflexible. There are other search options, but not directly within MySQL. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.