Hello,
I make an fulltext index on a column 'detailannonce' of a table 'apptcv'.
When I made this select :
SELECT apptcv.*, match (detailannonce) against (' jardin ') as relevance
FROM apptcv WHERE match (detailannonce) against ('jardin')>0 HAVING
relevance>0 ORDER BY relevance DESC
I didn't have any row in result.
If I made this another select :
SELECT apptcv.* FROM apptcv WHERE detailannonce like '%jardin%'
I had about 6000 rows resulted.
And, if in the first select, I'm replace 'jardin' by 'piscine' or
another word, It's work fine and I have correct result.
What's about the word 'jardin' ? It is a word reserved by Mysql, or
perhaps it is in my stop list, but I did'nt find the file containing the
stop list in my system (max OS X)
Thanks for yours responses.
Greetings
Philippe BARRIELLE
---------------------------------------------------------------------------------------------------
* S.A. Editions et Publicites - ABRITEL *
109, La Canebière - B.P 2033 - 13201 Marseille cedex 01 - France
Tél : 33 (0)4 91 11 00 72 Wap : http://wap.abritel.fr
Email: [EMAIL PROTECTED] Web : http://www.abritel.fr
---------------------------------------------------------------------
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
