I have a table with a keyword field and a fulltext index on that
field. One of the records contains this field: American Cocker
Spaniel. Searches are supposed to be case-insensitive so WHERE
MATCH (keyword) AGAINST ('spaniel') should work but in fact
returns zero rows, although AGAINST ('Spaniel') does return the
row. Further, AGAINST ('Span*') and AGAINST('span*') both return
zero rows even though they ought to work. Any ideas about what
might be going on in this table (all is ok in other tables)?-- ================= Michael Southwell Vice President, Education NYPHP TRAINING: http://nyphp.com/Training/Indepth _______________________________________________ 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
