Rob,
If you are using BLOBs or VARCHAR you may run into some issues. I
normally use TEXT.
Perhaps, altering the column type may help.
ALTER TABLE `whatever_table_name` MODIFY `keyword` TEXT;
Re-index the column.
ALTER TABLE `whatever_table_name` ADD FULLTEXT(`keyword`);
Try a query.
SELECT * FROM `whatever_table_name` WHERE MATCH(`keyword`) AGAINST
('spaniel');
Also, ensure you have at least 10-15 records.
FULLTEXT has some limitations on number of records - don't remember the
exact number. It works only after it reaches a threshold.
Hope that helps.
Best,
Dev
Rob Marscher wrote:
On Apr 4, 2009, at 4:17 PM, Michael Southwell
<[email protected]> wrote:
I have a table with a keyword field and a fulltext index on that
field.
snip
Searches are supposed to be case-insensitive so WHERE
MATCH (keyword) AGAINST ('spaniel') should work but in fact
returns zero rows
What's the charset and collation for the field? Maybe it's binary.
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
_______________________________________________
New York PHP Community MySQL SIG
http://lists.nyphp.org/mailman/listinfo/mysql
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
