Hello all-
I have a question on searching via fulltext.
I have the following SQL statement:
var('SQLResultsID') = 'select *, MATCH
(product_id,product_name,product_desc) AGAINST("' + $sqlKeywordSearch + '") AS
SCORE from products WHERE MATCH (product_id,product_name,product_desc)
AGAI
Hi!
On Jan 07, Erlend Hopso Stromsvik wrote:
> > What I can easily do without breaking 4.0.x "gamma" status, is to add
> > command line switch --disable-fulltext-stopwords. It can help as a
> > temporary solution, untill a proper fix - per-index options, that is -
> > will be implemented.
>
> Tha
> What I can easily do without breaking 4.0.x "gamma" status, is to add
> command line switch --disable-fulltext-stopwords. It can help as a
> temporary solution, untill a proper fix - per-index options, that is -
> will be implemented.
That would be helpful for me, but what about Thomas Spahni's
Resending this, since the first one didn't seem to get posted on the MySQL
list.
> -Original Message-
> From: Erlend HopsÛ StrÛmsvik
> Sent: 7. januar 2003 10:18
> To: [EMAIL PROTECTED]
> Subject: RE: MySQL fulltext. Question about the stopword list
>
>
> &
On Mon, 6 Jan 2003, Sergei Golubchik wrote:
> > Does the stopword list have to be 'hardcoded' in myisam/ft_static.c?
>
> No, of course, it has not.
> The problem is, that I cannot implement something like
>
>CREATE TABLE ... ( ... FULLTEXT (...) WITHOUT STOPWORD LIST )
> or
>CREATE TABLE .
Hi!
On Jan 06, Erlend Hopsø Strømsvik wrote:
>
> Hi
>
> I'm currently using MySQL (4.0.4 recompiled) as our database for storing
> information about books.
> There are about 1.5mill book titles + other information in the database now.
>
> The fulltext search capabilities of MySQL have turned ou
Hi
I'm currently using MySQL (4.0.4 recompiled) as our database for storing
information about books.
There are about 1.5mill book titles + other information in the database now.
The fulltext search capabilities of MySQL have turned out to become very
good with the 4+ version and with a little tw
Hi there,
I am trying fulltext to speed up my queries; but what would the query
line be,
when I would like to match the phrase: "This is a text"?
With a like query i would do "WHERE column LIKE '%This Is a text%';"
I've tried "MATCH column AGAINST("'+this +is +a +test'");" but this
returns,
all