Full Text Search not working...
Posted: Sun Apr 18, 2010 5:28 pm
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".
Could this be because I'm using numerical values? I don't see how that would make a difference.
Code: Select all
SELECT DISTINCT `venues`.*, MATCH(`meta`, `name`, `vdescription`) AGAINST ('901') AS venuescore FROM `venues` WHERE (MATCH(`meta`, `name`, `vdescription`) AGAINST ('901'))