Re: fulltext match against and other WHERE clauses

[Brent Baisley]

I have no problem combining MATCH with WHERE and HAVING. Are you sure 
there is supposed to be matches? Also, you need to make sure that you 
are formatting your date correctly (yyyy-mm-dd) for searching in MySQL 
if it is a date field you are searching on.

On Jan 20, 2004, at 12:36 PM, Alex Bruckert wrote:

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
--
Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]