Skip to content

Instantly share code, notes, and snippets.

@3manuek

3manuek/most_freq_token.sql

Created April 27, 2016 20:37
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save 3manuek/692a628fc70228194396f33d6d76d4d9 to your computer and use it in GitHub Desktop.
Save 3manuek/692a628fc70228194396f33d6d76d4d9 to your computer and use it in GitHub Desktop.
Download ZIP
most frequent tokens
Raw
most_freq_token.sql
SELECT WORD,count(*)
FROM information_schema.INNODB_FT_INDEX_TABLE
group by WORD having count(*) > 1000
order by 2
limit 10;
+--------+----------+
| WORD | count(*) |
+--------+----------+
| should | 1023 |
| yet | 1027 |
| any | 1070 |
| like | 1071 |
| been | 1073 |
| first | 1080 |
| nor | 1087 |
| your | 1106 |
| thou | 1130 |
| shall | 1164 |
+--------+----------+
10 rows in set (5,40 sec)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment