mySQL FULL-TEXT search

Hello experts,

 I have a problem with full text search. Here is my situation:

 In DB I have LOG records in "maillog" table,
 with FULLTEXT index on "log" row.

 When I do a search, I do:
 
SELECT *
FROM maillog
WHERE MATCH (log) AGAINST ('some_string' IN BOOLEAN MODE)

 This is OK. Query is fast (0.15 sec on 500.000 records).
 BUT when I want to narrow the search and include additional search
 string, I have problems:

SELECT *
FROM maillog
WHERE MATCH (log) AGAINST ('some_string +another_string' IN BOOLEAN MODE)

 The number of returned results are the same in both queries. Only
 relevance changes.
 If I do double query, I mean, first search for one string, and then
 for another string inside this string, the query takes 20 seconds,
 which is too long.

 Any idea how to do full-text search for 2 or more search strings with
 AND as boolean operator?
 


--
Best regards,
Andrej
----------------
[email protected]
----------------



-- 
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe:    http://lists.mysql.com/[email protected]