Hi!
On Feb 07, Alain Fontaine - Consultant and developer wrote:
-- snip --
select
BienID
from
biens
where
MATCH(Notes) AGAINST('+appartemen* -lux* -prop*' IN BOOLEAN MODE)
-- snip --
This does not produce the correct result, whereas this does:
-- snip --
select
BienID
On Wed, 2002-01-16 at 18:51, [EMAIL PROTECTED] wrote:
Hi there.
I need to do this sentence:
select * from table1 where match column1 against word;
Try:
select * from table1 where match column1 against (word);
But it donĀ“t works becouse crate the column like this:
alter table table1 add
I think you need to do this:
ALTER TABLE table1 ADD FULLTEXT (column1)
I may be wrong though, and I too have a question.
Does adding the FULLTEXT index affect performance dramatically? If it does,
what is a better way to search for exact word matches in columns that may
contain thousands of
Use % instead of *
cheers
--
sherzodR
On 26 Nov 2001, Harald Fuchs wrote:
According to the manual, section New Features of Full-text Search to
Appear in MySQL 4.0:
* `*' is a truncation operator.
The query
SELECT COUNT(*) FROM documents WHERE MATCH(txt) AGAINST ('Versailles')
returns 2,
Hi!
On Nov 26, sherzodR wrote:
Use % instead of *
cheers
--
sherzodR
On 26 Nov 2001, Harald Fuchs wrote:
According to the manual, section New Features of Full-text Search to
Appear in MySQL 4.0:
* `*' is a truncation operator.
The query
SELECT COUNT(*) FROM documents
correct me if I'm mistaken, but I believe the latest version of mysql is
3.23.38
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesday, May 15, 2001 1:04 PM
To: [EMAIL PROTECTED]
Subject: MySQL 4.0 FULLTEXT SPEED
Hi Everyone,
On Tue, May 15, 2001 at 02:06:32PM -0400, Dave Carter wrote:
correct me if I'm mistaken, but I believe the latest version of mysql is
3.23.38
That's the released version, yes.
But you can pull a source copy of the MySQL 4.0 tree and compile it
yourself if you're in the mood for some fun. :-)