Help with a search query.

[sumlogic]

Hey SP,

I have been working on a little search page for a client and can't seem to get this nailed down.Search form looks like this:

Title: (FullText MySQL)
Author:
County:
State:

When I do a search for something like "Sacramento City Directory" from the title field,

The query that get run looks like this:

SELECT * FROM DATABASENAME WHERE MATCH(title) AGAINST('"Sacramento City Directory"' IN BOOLEAN MODE) ORDER BY state,county,title ASC

The result I get will only give back results that contain "Sacramento City Directory". What I need is to get a result set back with any row containing all of the words, in any order that occur in the title.

What am I doing wrong?

Thank SP,

Greg

[guelphdad]

I had a quick peek at the manual. I haven't performed one of these before. Seems like you need a plus symbol in front of each word like so:

  SELECT * FROM DATABASENAME 
  WHERE MATCH(title) 
 AGAINST('+Sacramento +City +Directory' IN BOOLEAN MODE) 
  ORDER BY state,county,title ASC

The spot in the manual for boolean full text search info if you or someone else needs it:
http://dev.mysql.com/doc/mysql/en/Fulltext_Boolean.html

[sumlogic]

Thanks man that was it!!! Good loooking out.