Help with a search query.
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)
When I do a search for something like "Sacramento City Directory" from the title field,
The query that get run looks like this:
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.
SELECT * FROM DATABASENAME WHERE MATCH(title) AGAINST('"Sacramento City Directory"' IN BOOLEAN MODE) ORDER BY state,county,title ASC
What am I doing wrong?