RE: mysql and FULLTEXT

[Rich Foreman]

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 words in each entry?  LIKE doesn't do it properly.  It
will find 'then Richard said to' when I search for Rich  and I don't want
that..

Thanks,

Rich Foreman

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] 
 
Hi there.


I need to do this sentence:
select * from table1 where match column1 against "word";

But it don´t works becouse crate the column like this:
alter table table1 add column1 varchar(100);

Well my question is:
How I should create the column1 to have fulltext for this query??

Thanks
Victor. 

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: mysql and FULLTEXT

[Diana Soares]

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 column1 varchar(100);

That's ok, but don't forget to create an index of type FULLTEXT.
(with ALTER TABLE or CREATE INDEX).

There is a good example in:
http://mysql.com/doc/F/u/Fulltext_Search.html

> Well my question is:
> How I should create the column1 to have fulltext for this query??
> 
> Thanks
> Victor.
> 
> 
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> 
-- 
Diana Soares


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php