FULLTEXT search in form of MATCH...AGAINST

2004-04-08 Thread Robb Kerr 
I can't seem to get a FULLTEXT search in the form of MATCH...AGAINST to
work. I even copied verbatim the example listed on mysql.com at
(http://www.mysql.com/doc/en/Fulltext_Search.html). When I use...

SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database')

it works as expected. However when I use...

SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('following')

it doesn't return any results.

I've got several tables with FULLTEXT indexes and on none of them can I get
this syntax to work. What's up?
-- 
Robb Kerr
Digital IGUANA
Helping Digital Artists Achieve their Dreams
http://www.digitaliguana.com
http://www.cancerreallysucks.org

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: FULLTEXT search in form of MATCH...AGAINST

2004-04-08 Thread Richard Davey 
Hello Robb,

Thursday, April 8, 2004, 4:30:46 PM, you wrote:

RK I've got several tables with FULLTEXT indexes and on none of them can I get
RK this syntax to work. What's up?

Your version of MySQL perhaps?

-- 
Best regards,
 Richard Davey
 http://www.phpcommunity.org/wiki/296.html



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: FULLTEXT search in form of MATCH...AGAINST

2004-04-08 Thread Victoria Reznichenko 
Robb Kerr [EMAIL PROTECTED] wrote:
 I can't seem to get a FULLTEXT search in the form of MATCH...AGAINST to
 work. I even copied verbatim the example listed on mysql.com at
 (http://www.mysql.com/doc/en/Fulltext_Search.html). When I use...
 
 SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database')
 
 it works as expected. However when I use...
 
 SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('following')
 
 it doesn't return any results.
 
 I've got several tables with FULLTEXT indexes and on none of them can I get
 this syntax to work. What's up?

Because 'following' is a stopword.


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





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]