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) A

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

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. Howe