# maxnum

SELECT MAX(MATCH (DATA,DOC) AGAINST('$search' in boolean mode)) as maxnum
FROM PLAINDATA WHERE MATCH (DATA,DOC) AGAINST ('$search' in boolean mode)";

# seuil de détail

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) >=  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 |