Jump to content

Question regarding full text search


watsmyname

Recommended Posts

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

Link to comment
https://forums.phpfreaks.com/topic/192221-question-regarding-full-text-search/
Share on other sites

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.