problem with fulltext search

[Dawn O'Brien]

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'
)
) AND service = 'tmn' AND last_run > now( )
ORDER BY score DESC , title ASC
LIMIT 200
The 'movie_details' table has 2 entries with the word 'another' in the title 
that have a last_run date greater than the current date, but the query is 
not returning any results.

I modified the query to ::
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 (
title
LIKE '%another%' OR description
LIKE '%another%'
) AND service = 'tmn' AND last_run > now( )
ORDER BY score DESC , title ASC
LIMIT 200
With this statement I'm getting the desired results, but it's obviously not 
efficient and takes approximately 35x longer to run than the first query.

Any thoughts as to why the first query isn't returning the proper results?
Thanks for the help in advance ...
:: dawn ::

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