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. Quote Link to comment 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' ? Quote Link to comment 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. Quote Link to comment 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. Quote Link to comment 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. 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.