sonal Posted December 9, 2011 Share Posted December 9, 2011 I'm trying to learn performing boolean search from chapter 6. I want to apply search on 2 tables: book_name column of book_master has FULLTEXT index. book_review column of book_trn has FULLTEXT index Following query gives error : Incorrect arguments to MATCH SELECT book_name, book_review FROM book_master b, user_book_trn t WHERE b.book_id = t.book_id AND MATCH(book_name, book_review) AGAINST('WISE BROWN') how to use columns from different tables in a fulltext search query? Link to comment Share on other sites More sharing options...
Larry Posted December 10, 2011 Share Posted December 10, 2011 You can't. You can only create a FULLTEXT search on a table with a FULLTEXT index and you can't create an index across two tables. Link to comment Share on other sites More sharing options...
Recommended Posts