# maxnumSELECT MAX(MATCH (DATA,DOC) AGAINST('$search' in boolean mode)) as maxnumFROM PLAINDATA WHERE MATCH (DATA,DOC) AGAINST ('$search' in boolean mode)";# seuil de détailSELECT distinct DOC, MATCH (DATA,DOC) AGAINST ('+world enterprise') as relevancy,MATCH (DATA,DOC) AGAINST ('+world enterprise' in boolean mode) as wrdcount from PLAINDATA,LABEL WHERE MATCH (DATA,DOC) AGAINST ('+world enterprise' in boolean mode) >= abs($maxnum) order by wrdcount DESC ,relevancy DESC;mysql> SELECT distinct DOC, MATCH (DATA,DOC) AGAINST ('+world enterprise') as relevancy, -> MATCH (DATA,DOC) AGAINST ('+world enterprise' in boolean mode) as wrdcount -> from PLAINDATA,LABEL WHERE MATCH (DATA,DOC) AGAINST ('+world enterprise' in boolean mode) >= 1 -> order by wrdcount DESC ,relevancy DESC;+---------------------------------------------------------------+-------------------+------------------+| DOC | relevancy | wrdcount |+---------------------------------------------------------------+-------------------+------------------+| Centre for Policy Studies- CPS.doc | 3.18848848342896 | 1.33333337306976 || World Energy Council- WEC.doc | 2.71872735023499 | 1 || World Energy Council- WEC.doc | 2.35706782341003 | 1 || World Energy Council- WEC.doc | 2.33115339279175 | 1 || World Energy Council- WEC.doc | 1.95973253250122 | 1 || Foreign Policy Center- FPC.doc | 1.56884276866913 | 1 || World Energy Council- WEC.doc | 1.47313380241394 | 1 || Royal Institute for International Relations -IRRI-KIIB.doc | 1.41755902767181 | 1 || World Energy Council- WEC.doc | 1.41290163993835 | 1 || Friends of Europe - FoE.doc | 1.365727186203 | 1 || World Energy Council- WEC.doc | 1.29899489879608 | 1 |