On Jul 28, 2008, at 12:15 PM, Michael Southwell wrote:
This query:
SELECT * FROM profile
WHERE MATCH( affiliations, exhibitions, workshops, biography,
clients, skills, other )
AGAINST ( 'arbus' )
returns an empty result set.
You probably got it by now... but you need the "IN BOOLEAN MODE"
modifier:
SELECT * FROM profile
WHERE MATCH( affiliations, exhibitions, workshops, biography, clients,
skills, other )
AGAINST ( 'arbus' IN BOOLEAN MODE)
I did this simple test:
create table profile ( clients text, fulltext idx_fulltext (clients) )
engine = myisam;
insert into table values ('Diane Arbus
Ansel Adams
International Center of Photography
Weegee');
select * from profile where match(clients) against ('arbus' in boolean
mode);
My row was returned. To order by relevance:
select * from profile where match(clients) against ('arbus' in boolean
mode) order by match(clients) against ('arbus');
-Rob
_______________________________________________
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
