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 Link to comment https://forums.phpfreaks.com/topic/192904-match-against-not-resulting-properly/ 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? Link to comment https://forums.phpfreaks.com/topic/192904-match-against-not-resulting-properly/#findComment-1016058 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? Link to comment https://forums.phpfreaks.com/topic/192904-match-against-not-resulting-properly/#findComment-1017601 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? Link to comment https://forums.phpfreaks.com/topic/192904-match-against-not-resulting-properly/#findComment-1017660 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.