watsmyname Posted February 16, 2010 Share Posted February 16, 2010 Hello, i have 4 tables, tbl_members, tbl_officers, tbl_comment_category and tbl_comments. The user comment on particular officer and they can choose a category on which they want to comment. And there is one searchbox which when submitted should do FULL TEXT search including 1. Name of person who posted comment [we have member_id field common in tbl_comments & tbl_members] 2. name of officer comment is for [we have officer_id field common in tbl_comments & tbl_officers] 3. comment category [we have cat_id field common in tbl_comments & tbl_category] 4. comment text [this is in tbl_comments] I know full text search is done by indexing a two or more fields in a table which have text or varchar datatype. But can we perform a full text search as i have described above? if yes how can we do please give some hints. Thanks watsmyname Quote Link to comment Share on other sites More sharing options...
watsmyname Posted February 16, 2010 Author Share Posted February 16, 2010 Hello, i have 4 tables, tbl_members, tbl_officers, tbl_comment_category and tbl_comments. The user comment on particular officer and they can choose a category on which they want to comment. And there is one searchbox which when submitted should do FULL TEXT search including 1. Name of person who posted comment [we have member_id field common in tbl_comments & tbl_members] 2. name of officer comment is for [we have officer_id field common in tbl_comments & tbl_officers] 3. comment category [we have cat_id field common in tbl_comments & tbl_category] 4. comment text [this is in tbl_comments] I know full text search is done by indexing a two or more fields in a table which have text or varchar datatype. But can we perform a full text search as i have described above? if yes how can we do please give some hints. Thanks watsmyname All i need is when user inputs the name of person who comments or the name of person who is commented or the category name of the comment or the string on comments, the query should fetch the matching data from the tbl_comments. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 16, 2010 Share Posted February 16, 2010 And what have you tried thusfar? Quote Link to comment Share on other sites More sharing options...
watsmyname Posted February 17, 2010 Author Share Posted February 17, 2010 And what have you tried thusfar? well i read somewhere that full text search in multiple table is not possible. And i made it work using normal query Thanks anyways 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.