> > row. Further, AGAINST ('Span*') and AGAINST('span*') both return
> > zero rows even though they ought to work.
>
> Sorry, brains turned off for that sentence. It should say this:
> Further, AGAINST ('Span*' IN BOOLEAN MODE ) works while the same with
> 'span*' does not. So again, the issue is that case seems to matter
> although it is not supposed to.
Can you show the schema definition for your table?
SHOW CREATE TABLE TableName;
H
_______________________________________________
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