SELECT count(isbn) AS NbreRep ,MATCH(titre,cat_niv_2) AGAINST('+Catherine*+Kalengula*' IN BOOLEAN MODE) AS score FROM ad_isbn WHERE actif = 'oui' AND ( MATCH(titre,cat_niv_2) AGAINST('+Catherine*+Kalengula*' IN BOOLEAN MODE) OR isbn='Catherine Kalengula' OR auteur LIKE '%Catherine Kalengula%' OR illustrateur LIKE '%Catherine Kalengula%' OR editeur LIKE '%Catherine Kalengula%' OR collection LIKE '%Catherine Kalengula%' OR cat_niv_2 LIKE '%Catherine Kalengula%' OR cat_niv_3 LIKE '%Catherine Kalengula%' ) ORDER BY score DESC ; Search - Auzou.co.uk