1 2 3 4 5 6 7
| $query = "SELECT id, nomsite, description, mcles, url, texte,(
(2.95 * (MATCH (nomsite) AGAINST ('$mots2' IN BOOLEAN MODE)))
+ (1.85 * (MATCH (description) AGAINST ('$mots2' IN BOOLEAN MODE)))
+ (1.05 * (MATCH (mcles) AGAINST ('$mots2' IN BOOLEAN MODE)))
+ (1.75 * (MATCH (url) AGAINST ('$mots2' IN BOOLEAN MODE)))
+ (2.50 * (MATCH (texte) AGAINST ('$mots2' IN BOOLEAN MODE))) ) AS relevance FROM $tableannu
WHERE ( MATCH (nomsite , description, mcles, url, texte) AGAINST ('$mots2' IN BOOLEAN MODE) ) AND valid='0' HAVING relevance > 0 ORDER BY relevance DESC LIMIT $debut,$limit"; |
Partager