mabus Posted September 7, 2008 Share Posted September 7, 2008 How do you perform a full text search on more than one table, in one query? This, of course has tables with columns indexed as full text. Link to comment https://forums.phpfreaks.com/topic/123098-how-to-do-full-text-search-on-more-than-one-table/ Share on other sites More sharing options...
Ken2k7 Posted September 7, 2008 Share Posted September 7, 2008 Can you be a little more descriptive? SELECT * FROM `table_one` INNER JOIN `table_two` ON (`table_one`.textfieldname = `table_two`.textfieldname) WHERE `table_one`.textfieldname = '$sometext' ? Link to comment https://forums.phpfreaks.com/topic/123098-how-to-do-full-text-search-on-more-than-one-table/#findComment-635890 Share on other sites More sharing options...
mabus Posted September 8, 2008 Author Share Posted September 8, 2008 I want to be able to implement full text searching. Apparently, I am only able to do it on one table. What I am looking for is how I may be able to do it on more than one tables. The tables that I will be using already has some colums / fields indexed to be full text, and all I need is a sample query on how I may go about doing so. Link to comment https://forums.phpfreaks.com/topic/123098-how-to-do-full-text-search-on-more-than-one-table/#findComment-636232 Share on other sites More sharing options...
fenway Posted September 8, 2008 Share Posted September 8, 2008 MySQL doesn't support this natively... look at lucene or sphinx. Link to comment https://forums.phpfreaks.com/topic/123098-how-to-do-full-text-search-on-more-than-one-table/#findComment-636251 Share on other sites More sharing options...
snk Posted September 8, 2008 Share Posted September 8, 2008 i think he wants to search inside a value with biiiig text. try LIKE it will return similar results but not equal. Link to comment https://forums.phpfreaks.com/topic/123098-how-to-do-full-text-search-on-more-than-one-table/#findComment-636390 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.