mysql fulltext boolean mode
voici une requete qui ne fonctionne pas: vous avez une idée?
Citation:
" SELECT stage.id AS id, stage.ref AS ref, stage.rubrique_id AS rubrique_id, stage.sous_rubrique_id AS sous_rubrique_id, stage.intitule AS intitule, stage.ref AS ref, stage.duree AS duree, stage.duree_mult AS duree_mult, stage.jour_supp AS jour_supp, stage.intra_uniq AS intra_uniq, stage.prix AS prix, stage.objectifs AS objectifs, stage.personnes AS personnes, stage.animation AS animation, stage.contenu AS contenu, stage.nouveau AS nouveau, stage.formaction AS formaction, rubrique.nom AS rubrique_nom, sous_rubrique.nom AS sous_rubrique_nom
FROM stage
INNER JOIN rubrique ON rubrique.id = stage.rubrique_id
LEFT OUTER JOIN sous_rubrique ON sous_rubrique.id = stage.sous_rubrique_id
WHERE (
MATCH (
stage.intitule, stage.objectifs, stage.contenu, stage.animation, stage.personnes, stage.keywords
)
AGAINST (
'toto* d\'toto* l\'toto* m\'toto* n\'toto* s\'toto* t\'toto*'
IN BOOLEAN
MODE
)
)
AND stage.publier =1
LIMIT 0 , 30 "
ellle fonctionne en local (version php: 4.3.3 mysql:3.23.49) mais en ligne sur un serveur dedié (php:4.3.11 , mysql: 3.23.58 ) elle repond:
#1064 - You have an error in your SQL syntax near 'BOOLEAN MODE ) ) AND stage . publier = 1 LIMIT 0, 30 ' at line 1
merci d'avance!
