MySQL Forums
Forum List  »  Full-Text Search

Search item not found
Posted by: Bill Angus
Date: July 21, 2006 07:05PM

I'm trying to set up a database search powered by MySQL full-text index with the following fields:
title and author are both char(55)
comments is longtext
acronym is char(15)
When I execute the following query,
I get a result set on words in the TITLE field, but I get no results if I enter a valid acronym.

e.g. I have a word MSCEIT as an acronym. However if I enter MSCEIT I get a null set. But if I enter words in a title, there is a result set with no obvious problems.

Here is my query in PHP:
$query1 = "SELECT refnum,name,name2,comments,date,intcode,acronym FROM pminvtry WHERE intcode<900 AND MATCH (name,name2,comments,acronym) AGAINST('$searchstr' ) LIMIT $start, $results_per_page ; ";

ANY Help greatly appreciated.

Options: ReplyQuote

Written By
Search item not found
July 21, 2006 07:05PM

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.