jraede Posted April 20, 2010 Share Posted April 20, 2010 I just tried to implement full text searching to my database. It's working for the most part, but when I search for numbers, it doesn't return the rows as expected. For example, I have a table of venues, and one is called "901 Bar and Grill". When I search for "901 bar" my query looks like this: SELECT DISTINCT `venues`.*, MATCH(`meta`, `name`, `vdescription`) AGAINST ('901 bar') AS venuescore FROM `venues` WHERE (`vpending` = '0') AND (MATCH(`meta`, `name`, `vdescription`) AGAINST ('901 bar')) The specific entry for 901 bar looks like this: name: 901 Bar & Grill meta: 9-0 nine-o 90 Shouldn't this show up with a search for "901 bar"? Thanks for any help. Quote Link to comment https://forums.phpfreaks.com/topic/199102-full-text-search-problem/ Share on other sites More sharing options...
fenway Posted April 23, 2010 Share Posted April 23, 2010 FULLTEXT is funny -- depends how common these phrases are. Quote Link to comment https://forums.phpfreaks.com/topic/199102-full-text-search-problem/#findComment-1047058 Share on other sites More sharing options...
jdavidbakr Posted April 28, 2010 Share Posted April 28, 2010 You might also look at boolean mode, which will return more results. Also, the minimum string length (I think, off the top of my head) is 4 characters - so "901" wouldn't ever match in that case. FullText is very cool but it is definitely not as straightforward as other conditions. Quote Link to comment https://forums.phpfreaks.com/topic/199102-full-text-search-problem/#findComment-1050115 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.