InnoDB and Fulltext Search

2002-04-22 Thread Ang Ho Keat 

Hi,

Quote from mysql online documentations:
As of Version 4.0.1, MySQL can also perform boolean
full-text
searches using the IN BOOLEAN MODE modifierA
boolean full-text
search can also work even without a FULLTEXT index,
although it would
be slow. 

I know that InnoDB does not support FULLTEXT INDEXING
but can i
perform a fulltext search on an InnoDB table? I tried
but it doesn't
seem to work. The 'match... against()' returns a value
of '-1'. Any
idea?

Thanx.

ahk


__
Do You Yahoo!?
Yahoo! Messenger - Instant Messaging, Instant Gratification. (Now with new emoticons!)
http://messenger.yahoo.com.sg/

-
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: InnoDB and Fulltext Search

2002-04-22 Thread Victoria Reznichenko 

Ang,
Monday, April 22, 2002, 12:24:58 PM, you wrote:

AHK Quote from mysql online documentations:
AHK As of Version 4.0.1, MySQL can also perform boolean
AHK full-text
AHK searches using the IN BOOLEAN MODE modifierA
AHK boolean full-text
AHK search can also work even without a FULLTEXT index,
AHK although it would
AHK be slow. 

AHK I know that InnoDB does not support FULLTEXT INDEXING
AHK but can i
AHK perform a fulltext search on an InnoDB table? I tried
AHK but it doesn't
AHK seem to work. The 'match... against()' returns a value
AHK of '-1'. Any
AHK idea?

No, Full-text search still works only on MyISAM tables ...

AHK Thanx.
AHK ahk




-- 
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   ___/   www.mysql.com




-
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