anujgarg Posted February 22, 2010 Share Posted February 22, 2010 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 Quote Link to comment Share on other sites More sharing options...
sader Posted February 22, 2010 Share Posted February 22, 2010 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? Quote Link to comment Share on other sites More sharing options...
anujgarg Posted February 24, 2010 Author Share Posted February 24, 2010 Thanks for the reply. But is there any other solution apart from this? Quote Link to comment Share on other sites More sharing options...
fenway Posted February 24, 2010 Share Posted February 24, 2010 FULLTEXT is funny if you don't have a lot of records -- also, what's your min_word_length? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.