Full Text Search Help!

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
zink
Forum Newbie
Posts: 6
Joined: Sun Jul 09, 2006 3:43 pm

Full Text Search Help!

Post by zink »

Hey

Having big time problems with my full text search on my site. Think its a pretty easy one though for you PHP gurus :wink:

The following query does not bring back any records but they are definitely there!! For example the category field contains the words "Designer Men" and the brand is "Duck And Cover" (in the mySQL db). This code is a direct copy of another query but for "ladies ladie women women's" and it works prefectly this is why i do not understand it!!

Here is the offender:

Code: Select all

$num3 = getPORProducts("SELECT * FROM por WHERE MATCH(longDescription, category, description, brand, name) AGAINST('+\"Duck & Cover\" \"Duck and Cover\" \"Duck & Cover\" +(mens men\'s men)' IN BOOLEAN MODE)");
p.s. to save you some time the problem is definitely with the code above, and has nothing to do with the functions i have created.

Cheers for your help!
-Zink
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

full-text search & query = Databases. Moved.
zink
Forum Newbie
Posts: 6
Joined: Sun Jul 09, 2006 3:43 pm

Post by zink »

Feel free to help feyd :lol: ?
zink
Forum Newbie
Posts: 6
Joined: Sun Jul 09, 2006 3:43 pm

Post by zink »

bump :cry:
zink
Forum Newbie
Posts: 6
Joined: Sun Jul 09, 2006 3:43 pm

Post by zink »

hey i figured this out if anyone is interested!

Basically there is a minimum character limit of 4. and i was trying to bring back results using a 3 character string "men". This server variable "ft_min_word_len" can be updated but it has to be done at mySQL server startup. Unfortunately I am on a shared platform and cant see my host doing this for me. :lol:

Cheers
Post Reply