smith.james0 Posted February 10, 2007 Share Posted February 10, 2007 I am trying to search a mysql db using MATCH, with the following code SELECT * FROM `*******`WHERE MATCH (retro_answer)AGAINST ('car')LIMIT 0 , 30 but all I get is MySQL returned an empty result set (i.e. zero rows). (Query took 0.0006 sec) This is contance of the db id Name retro_answer 68 JAmes car bus train 69 JAmes car bus train Retro_answer is Full_Text. Whatever I do I still get no results? Can anyone help, Many thanks James Link to comment https://forums.phpfreaks.com/topic/37881-sql-match-problem/ Share on other sites More sharing options...
richardw Posted February 10, 2007 Share Posted February 10, 2007 take a look at this article in the Database Journal on full text searches. http://www.databasejournal.com/features/mysql/article.php/1578331 Best, Link to comment https://forums.phpfreaks.com/topic/37881-sql-match-problem/#findComment-181364 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.