Search item not found
I'm trying to set up a database search powered by MySQL full-text index with the following fields:
-----
title
author
comments
acronym
-------
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.
Subject
Views
Written By
Posted
Search item not found
3133
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.