Topic: Match Against not resulting properly

[anujgarg]

Hi,

I am executing following query:

SELECT *
FROM `table` AS video
WHERE video.public_private = 'public'
AND MATCH (
title, tags, description
)
AGAINST (
'avi'
)
AND video.published =1

But, it doesn't display the proper records matching with the text 'avi'. It exists in the field name "description" but it shows:
MySQL returned an empty result set (i.e. zero rows).

Please suggest how to solve this query...

Thanks
Anuj

[sader]

try in boolen mode

AGAINTS(`avi` IN BOOLEAN MODE)

not sure what this does but it helped in my case

another think are your fields `title`, `tags`, `description` indexed with fulltext mode?

[anujgarg]

Thanks for the reply. But is there any other solution apart from this?

[fenway]

FULLTEXT is funny if you don't have a lot of records -- also, what's your min_word_length?