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 Link to comment https://forums.phpfreaks.com/topic/26789-full-text-search/ 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. Link to comment https://forums.phpfreaks.com/topic/26789-full-text-search/#findComment-122776 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.