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

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

"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