mysql> CALL occurences('gn');
+--------------------+--------------------+-------------+
| pseudo | nombre de textes : | contenant : |
+--------------------+--------------------+-------------+
| Lapinchien | 220 | gn |
| nihil | 216 | gn |
| Mill | 90 | gn |
| HaiKulysse | 88 | gn |
| Dourak Smerdiakov | 56 | gn |
| Zone Inc. | 55 | gn |
| pascal dandois | 54 | gn |
| Aka | 53 | gn |
| Nounourz | 46 | gn |
| Arkanya | 46 | gn |
| Konsstrukt | 42 | gn |
| Glaüx-le-Chouette | 40 | gn |
| Kirunaa | 39 | gn |
| Tulia | 38 | gn |
| Narak | 32 | gn |
| Cuddle | 30 | gn |
| Clacker | 27 | gn |
| Traffic | 26 | gn |
| Nico | 26 | gn |
| Scorbut | 25 | gn |
+--------------------+--------------------+-------------+
20 rows in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnn');
+----------------+--------------------+-------------+
| pseudo | nombre de textes : | contenant : |
+----------------+--------------------+-------------+
| Koax-Koax | 2 | gnn |
| Lapinchien | 1 | gnn |
| Aka | 1 | gnn |
| Narak | 1 | gnn |
| Ange Verhell | 1 | gnn |
| Lembaumeur | 1 | gnn |
| Yog | 1 | gnn |
| pascal dandois | 1 | gnn |
+----------------+--------------------+-------------+
8 rows in set (0.04 sec)
Query OK, 0 rows affected (0.04 sec)
mysql> CALL occurences('gnnn');
+------------+--------------------+-------------+
| pseudo | nombre de textes : | contenant : |
+------------+--------------------+-------------+
| Lapinchien | 1 | gnnn |
| Aka | 1 | gnnn |
| Narak | 1 | gnnn |
| Lembaumeur | 1 | gnnn |
| Koax-Koax | 1 | gnnn |
| Yog | 1 | gnnn |
+------------+--------------------+-------------+
6 rows in set (0.10 sec)
Query OK, 0 rows affected (0.10 sec)
mysql> CALL occurences('gnnnn');
+------------+--------------------+-------------+
| pseudo | nombre de textes : | contenant : |
+------------+--------------------+-------------+
| Lapinchien | 1 | gnnnn |
| Narak | 1 | gnnnn |
| Koax-Koax | 1 | gnnnn |
| Yog | 1 | gnnnn |
+------------+--------------------+-------------+
4 rows in set (0.08 sec)
Query OK, 0 rows affected (0.08 sec)
mysql> CALL occurences('gnnnnn');
+------------+--------------------+-------------+
| pseudo | nombre de textes : | contenant : |
+------------+--------------------+-------------+
| Lapinchien | 1 | gnnnnn |
| Narak | 1 | gnnnnn |
+------------+--------------------+-------------+
2 rows in set (0.07 sec)
Query OK, 0 rows affected (0.07 sec)
mysql> CALL occurences('gnnnnnn');
+------------+--------------------+-------------+
| pseudo | nombre de textes : | contenant : |
+------------+--------------------+-------------+
| Lapinchien | 1 | gnnnnnn |
| Narak | 1 | gnnnnnn |
+------------+--------------------+-------------+
2 rows in set (0.07 sec)
Query OK, 0 rows affected (0.07 sec)
mysql> CALL occurences('gnnnnnnn');
+--------+--------------------+-------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-------------+
| Narak | 1 | gnnnnnnn |
+--------+--------------------+-------------+
1 row in set (0.06 sec)
Query OK, 0 rows affected (0.06 sec)
mysql> CALL occurences('gnnnnnnnn');
+--------+--------------------+-------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-------------+
| Narak | 1 | gnnnnnnnn |
+--------+--------------------+-------------+
1 row in set (0.05 sec)
Query OK, 0 rows affected (0.05 sec)
mysql> CALL occurences('gnnnnnnnnn');
+--------+--------------------+-------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-------------+
| Narak | 1 | gnnnnnnnnn |
+--------+--------------------+-------------+
1 row in set (0.05 sec)
Query OK, 0 rows affected (0.05 sec)
mysql> CALL occurences('gnnnnnnnnnn');
+--------+--------------------+-------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-------------+
| Narak | 1 | gnnnnnnnnnn |
+--------+--------------------+-------------+
1 row in set (0.05 sec)
Query OK, 0 rows affected (0.05 sec)
mysql> CALL occurences('gnnnnnnnnnnn');
+--------+--------------------+--------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+--------------+
| Narak | 1 | gnnnnnnnnnnn |
+--------+--------------------+--------------+
1 row in set (0.05 sec)
Query OK, 0 rows affected (0.05 sec)
mysql> CALL occurences('gnnnnnnnnnnnn');
+--------+--------------------+---------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+---------------+
| Narak | 1 | gnnnnnnnnnnnn |
+--------+--------------------+---------------+
1 row in set (0.04 sec)
Query OK, 0 rows affected (0.04 sec)
mysql> CALL occurences('gnnnnnnnnnnnnn');
+--------+--------------------+----------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+----------------+
| Narak | 1 | gnnnnnnnnnnnnn |
+--------+--------------------+----------------+
1 row in set (0.04 sec)
Query OK, 0 rows affected (0.04 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnn');
+--------+--------------------+-----------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-----------------+
| Narak | 1 | gnnnnnnnnnnnnnn |
+--------+--------------------+-----------------+
1 row in set (0.04 sec)
Query OK, 0 rows affected (0.04 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnn');
+--------+--------------------+------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+------------------+
| Narak | 1 | gnnnnnnnnnnnnnnn |
+--------+--------------------+------------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnn');
+--------+--------------------+-------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnn |
+--------+--------------------+-------------------+
1 row in set (0.04 sec)
Query OK, 0 rows affected (0.04 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnn');
+--------+--------------------+--------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+--------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnn |
+--------+--------------------+--------------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnn');
+--------+--------------------+---------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+---------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnn |
+--------+--------------------+---------------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+----------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+----------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+----------------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+-----------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-----------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+-----------------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+------------------------+
1 row in set (0.04 sec)
Query OK, 0 rows affected (0.04 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+-------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+-------------------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+--------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+--------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+--------------------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+---------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+---------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+---------------------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+----------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+----------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+----------------------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+-----------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-----------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+-----------------------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+------------------------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+-------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+-------------------------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+--------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+--------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+--------------------------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+---------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+---------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+---------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+----------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+----------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+----------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+-----------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-----------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+-----------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+------------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+-------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+-------------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+--------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+--------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+--------------------------------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+---------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+---------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+---------------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+----------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+----------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+----------------------------------------+
1 row in set (0.01 sec)
Query OK, 0 rows affected (0.01 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+-----------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-----------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+-----------------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+------------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+------------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+------------------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+-------------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-------------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+-------------------------------------------+
1 row in set (0.03 sec)
Query OK, 0 rows affected (0.03 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+--------------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+--------------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+--------------------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+---------------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+---------------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+---------------------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+----------------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+----------------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+----------------------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+-----------------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-----------------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+-----------------------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+------------------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+------------------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+------------------------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+-------------------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-------------------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+-------------------------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+--------------------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+--------------------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+--------------------------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+---------------------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+---------------------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+---------------------------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+----------------------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+----------------------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+----------------------------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
+--------+--------------------+-----------------------------------------------------+
| pseudo | nombre de textes : | contenant : |
+--------+--------------------+-----------------------------------------------------+
| Narak | 1 | gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn |
+--------+--------------------+-----------------------------------------------------+
1 row in set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnn');
Empty set (0.02 sec)
Query OK, 0 rows affected (0.02 sec)
mysql> CALL occurences('gni ?');
+------------+--------------------+-------------+
| pseudo | nombre de textes : | contenant : |
+------------+--------------------+-------------+
| Lapinchien | 1 | gni ? |
+------------+--------------------+-------------+
1 row in set (0.09 sec)
Query OK, 0 rows affected (0.09 sec)