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:
Code:
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