MySQL Forums
Forum List  »  Full-Text Search

Questions on full text searching
Posted by: Qadoshyah Fish
Date: January 29, 2010 11:23AM

Hi all,

I'm fairly new to PHP & MySQL. I have a PHP search that I built on my site, but now I'm realizing I need to use full text searching because I have so many tables and entries that will need to be searched from.

I have multiple tables joined into my search. At the moment this is what I have to return results:

WHERE asmnt_parcel.Account = '{$search}' OR asmnt_parcel.OwnersName = '{$search}' OR asmnt_parcel.ParcelID = '{$search}' OR asmnt_legal.Legal = '{$search}' OR appr_miscimpr.Account = '{$search}'

I realize this is going to slow things down big time, since I'll have to do that for all 8 or 9 tables I have joined in, since certain account numbers are in one table, but aren't in another table.

So . . . . I have some questions on full text searching.

I've read several tutorials and it seems like a fairy easy concept. But, I have a few questions to help my understanding of this:

-- Since I have multiple tables that I've joined into my search, do I need to put the MATCH or WHERE MATCH statements at the end of every table I have joined in?
-- Are the AGAINST statements necessary? I assume so. If so, how do I make it so that it is just a wildcard or something along those lines, so that it'll return any search that is put in? Like, for example, there are thousands of Account numbers and they are all different, I can't list every single one in the code, so that it is pulled up when searched. I'm sure there's a way where I can just use a $search or something at that point and not have to put the exact word that needs to be searched. See where I'm a little confused? How do I do that?
-- Do I need to index every field in the tables that I want to be fulltext searched?

Thanks for any and all help, it is greatly appreciated!!


Options: ReplyQuote

Written By
Questions on full text searching
January 29, 2010 11:23AM
February 07, 2010 01:46PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.