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,
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
