Hello,
I am evaluating mySQL 4.0.1-alpha on Redhat Linux 7.2 (RPM version). I am
playing with the new fulltext search features and I have a question
regarding the syntax...
I have created a fulltext index on a field 'Notes'. I'd like to search for
records that have words starting with "appartemen" in them, but NOT words
starting with "lux", and neither with "prop". So I thought this would do the
trick:
<-- snip -->
select
BienID
from
biens
where
MATCH(Notes) AGAINST('+appartemen* -lux* -prop*' IN BOOLEAN MODE)
<-- snip -->
This does not produce the correct result, whereas this does:
<-- snip -->
select
BienID
from
biens
where
MATCH(Notes) AGAINST('appartemen*' IN BOOLEAN MODE)
AND
NOT MATCH(Notes) AGAINST('lux*' IN BOOLEAN MODE)
AND
NOT MATCH(Notes) AGAINST('prop*' IN BOOLEAN MODE)
<-- snip -->
What have I understood wrong?
-----------------------
Alain Fontaine
Consultant & Developer
VAlain S.A.
Tél: +32-4-2522950
-----------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
