GH schrieb:
Laura did this work... inquiring minds want to know :)
Laura:
Perhaps the "-" is acting like a Boolean operator. What if you put
double quotes around your search phrase:
SELECT * FROM metadata WHERE MATCH( type ) AGAINST ( '+"XY-11443"' IN
BOOLEAN MODE );
Or.. the - is possibly suppose
Laura did this work... inquiring minds want to know :)
On Wed, 29 Sep 2004 13:36:40 -0400, Wesley Furgiuele
<[EMAIL PROTECTED]> wrote:
> Laura:
>
> Perhaps the "-" is acting like a Boolean operator. What if you put
> double quotes around your search phrase:
>
> SELECT * FROM metadata WHERE MATC
Laura:
Perhaps the "-" is acting like a Boolean operator. What if you put
double quotes around your search phrase:
SELECT * FROM metadata WHERE MATCH( type ) AGAINST ( '+"XY-11443"' IN
BOOLEAN MODE );
Wes
On Wed, 29 Sep 2004 13:22:54 -0400, Laura Scott <[EMAIL PROTECTED]> wrote:
>
>
> Hello,
Hello,
I have a questions with limitations/restrictions that are around for
full text search.
I have a field with data like "XY-11443;." and I need to find the
record. The original developer was using full text search and says that
all was working before the task switched hands.
The basic
Hi!
On Apr 03, Oson, Chris M. wrote:
> Hello,
>
> I have a site that I'm trying to implement a search engine on existing and
> archived news stories on a medium text datatype in a database.
>
> I read the documentation and got it running, but unless I missed something
> it's not doing what I
Oson take a look at mysql documentantion. You can do this with match
against.
A IR system is somewhat different than a DB. But mysql is both an IR and
a DB.
Oson, Chris M. wrote:
> Hello,
>
> I have a site that I'm trying to implement a search engine on existing and
> archived news stories o
My apologies, I didn't clarify that I *was* using a full-text search.
-Original Message-
From: Lindsay Adams [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 11:52 AM
To: [EMAIL PROTECTED]
Subject: Re: Full Text Search Question
To do a full word match like you are wanting
To do a full word match like you are wanting, you would need to break up the
sql query to do this:
... WHERE field LIKE "%word1%" AND field LIKE "%word2%" ...
That is how you have to do it if you are not using one of the latest 3.23
versions of mysql. If you have a newer version of mysql, check
Hello,
I have a site that I'm trying to implement a search engine on existing and
archived news stories on a medium text datatype in a database.
I read the documentation and got it running, but unless I missed something
it's not doing what I want it to do.
For example, if I put in the keyword
