Results 1 to 3 of 3
Thread: Help with a search query.
Jan 21, 2005, 10:18 #1
- Join Date
- Jan 2005
- 0 Post(s)
- 0 Thread(s)
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:Code:
SELECT * FROM DATABASENAME WHERE MATCH(title) AGAINST('"Sacramento City Directory"' IN BOOLEAN MODE) ORDER BY state,county,title ASC
What am I doing wrong?