Problem with FullText Indexes

I am trying to do a fulltext search with a multi-field index using MySQL 4.1.15. When I create a full text index of my Comments field which is of type TEXT. I can do a fulltext search fine. But when I add another field (like a varchar or even Text) to that index or change the name of the index I

Re: problem with fulltext search

"another" is a stop word. The default list of stopwords is in myisam/ft_static.c in a source distribution. See the manual for more . Michael Dawn O'Brien wrote: I'm trying to use the following query :: SELECT movie_id, title, genre,

problem with fulltext search

I'm trying to use the following query :: SELECT movie_id, title, genre, description, TRIM( TRAILING ',' FROM actors ) , director, disclaimer, rating, year, ( MATCH ( title, description ) AGAINST ( 'another' ) ) AS score FROM movie_details WHERE ( MATCH ( title, description ) AGAINST ( 'another' ) )

Re: Problem with FULLTEXT searches

Ok, I added IN BOOLEAN MODE and now it somewhat works...It is just a matter of optimizing it now. Thanks. - Original Message - From: "Cliff" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 8:13 AM Subject: Problem with FULLTEXT searches &g

Problem with FULLTEXT searches

I am trying to get the fulltext search working properly as described in the manual but some queries do not seem to be working correctly. When I run this query: SELECT allusa.name,title,full_text,match(title,full_text) against ('chicken soup lemon') from recipes, bb.allusa where innid = bb.allusa.i

Problem with FULLTEXT

Philippe, Monday, February 11, 2002, 12:28:47 PM, you wrote: P> Hello, P> I make an fulltext index on a column 'detailannonce' of a table 'apptcv'. P> When I made this select : P> SELECT apptcv.*, match (detailannonce) against (' jardin ') as relevance P> FROM apptcv WHERE match (detailannonc

Problem with FULLTEXT

Hello, I make an fulltext index on a column 'detailannonce' of a table = 'apptcv'. When I made this select : SELECT apptcv.*, match (detailannonce) against (' jardin ') as relevance=20= FROM apptcv WHERE match (detailannonce) against ('jardin')>0 HAVING=20 relevance>0 ORDER BY relevance DESC I

Problem with FULLTEXT

Philippe, Monday, February 11, 2002, 12:28:47 PM, you wrote: P> Hello, P> I make an fulltext index on a column 'detailannonce' of a table 'apptcv'. P> When I made this select : P> SELECT apptcv.*, match (detailannonce) against (' jardin ') as relevance P> FROM apptcv WHERE match (detailannonc

Problem with FULLTEXT

Hello, I make an fulltext index on a column 'detailannonce' of a table 'apptcv'. When I made this select : SELECT apptcv.*, match (detailannonce) against (' jardin ') as relevance FROM apptcv WHERE match (detailannonce) against ('jardin')>0 HAVING relevance>0 ORDER BY relevance DESC I didn't h

Problem with Fulltext search

I'm using a MySQL ver. 3.23.41 And I don't seem to be able to create a FullText index. Below is my Table and the index I want to add. create table cal_bruger( ID int(4) unsigned zerofill NOT NULL auto_increment, Navn varchar(20) binary NOT NULL , EfterNavn varchar(20) binary NOT NULL , adresse va

Problem with FULLTEXT index

Using MySQL version 3.23.39 on a Win2k server with SP2, I have some problems with the FULLTEXT index. I have a table created like this: CREATE TABLE `visitkort` ( `id` int(10) unsigned NOT NULL auto_increment, `kategori_id` int(10) unsigned NOT NULL default '0', `aktiv` tinyint(3) unsigned

"Error 127 from table handler" - Problem with FULLTEXT search

Hi, I have got a table with an index and apparently it crashed and I cannot get anymore results :-( with a MATCH AGAINST query. I have tried to repair the table (which contains only 2 rows) with myisamchk but it doesn't change anything (maybe I used the wrong options: I used -e and -r) One query