Hi There i use a query:
SELECT * FROM volltexttabelle ft LEFT JOIN suchtabelle s ON s.article_id = ft.article_id WHERE MATCH (ft.index_text) AGAINST ('+"equator" ' IN BOOLEAN MODE ) which works fine now i want to modify it ie add AND s.search_date>=1980 or other clauses which cant be handled by the MATCH part is this possible? i always receive no matching results when trying that, am i just doing something wrong? or is this just not supposed to be done that way thanks for help Alex -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]