SELECT count(isbn) AS NbreRep ,MATCH(titre,cat_niv_2) AGAINST('"Yi-hsuan"' IN BOOLEAN MODE) AS score FROM ad_isbn WHERE actif = 'oui' AND ( MATCH(titre,cat_niv_2) AGAINST('"Yi-hsuan"' IN BOOLEAN MODE) OR isbn='Yi-hsuan Wu' OR auteur LIKE '%Yi-hsuan Wu%' OR illustrateur LIKE '%Yi-hsuan Wu%' OR editeur LIKE '%Yi-hsuan Wu%' OR collection LIKE '%Yi-hsuan Wu%' OR cat_niv_2 LIKE '%Yi-hsuan Wu%' OR cat_niv_3 LIKE '%Yi-hsuan Wu%' ) ORDER BY score DESC ;
Page 1 2