Page 1 of 1

Full Text Search not working...

Posted: Sun Apr 18, 2010 5:28 pm
by jraede
I just tried to add full-text searching to a database. I ran this query: mysql_query("ALTER TABLE `venues` ADD FULLTEXT(`meta`, `name`, `vdescription)");. Now I can search for things like "pete's bar" and it will show up as expected, using MATCH(`meta, `name`, `vdescription`) AGAINST('petes bar'). However, when I have this query, I get no match, even though the value "901" is in a venue's name column (the venue's name is "901 Bar & Grill".

Code: Select all

SELECT DISTINCT `venues`.*, MATCH(`meta`, `name`, `vdescription`) AGAINST ('901') AS venuescore FROM `venues` WHERE (MATCH(`meta`, `name`, `vdescription`) AGAINST ('901'))
Could this be because I'm using numerical values? I don't see how that would make a difference.

Re: Full Text Search not working...

Posted: Fri Apr 23, 2010 9:39 pm
by yacahuma
i dont know much about full text search, but are your using myisam tables?

Re: Full Text Search not working...

Posted: Fri Apr 23, 2010 9:56 pm
by Benjamin