Hi!
Maybe it is case sensitive? What happens when you change the query to end in
AGAINST ( 'Arbus' )
??
Other than that I have to pass.
David
Michael Southwell wrote:
I have a table "profile" with fields affiliations, exhibitions,
workshops, biography, clients, skills, other (along with others).
This table has a fulltext index over these seven fields.
This is test data so there is only one row. The clients field in this
row contains this data:
Diane Arbus
Ansel Adams
International Center of Photography
Weegee
There is no problem displaying the data. But I can't search
successfully. This query:
SELECT * FROM profile
WHERE MATCH( affiliations, exhibitions, workshops, biography, clients,
skills, other )
AGAINST ( 'arbus' )
returns an empty result set.
I've done this elsewhere, but in this case I can't figure out why it
isn't working. I tried a simpler fulltext index on just clients, but
that didn't work either. Does anybody see what I'm doing wrong?
_______________________________________________
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
