Skip to content

Instantly share code, notes, and snippets.

@peterkimzz

peterkimzz/ngram.sql

Last active April 25, 2019 05:34
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save peterkimzz/92a4aa7e2dbed16d26b92a003c878aef to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save peterkimzz/92a4aa7e2dbed16d26b92a003c878aef to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. peterkimzz revised this gist Apr 25, 2019. 1 changed file with 5 additions and 1 deletion.
    6 changes: 5 additions & 1 deletion ngram.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,8 @@
    ALTER TABLE TABLE_NAME ADD FULLTEXT INDEX ngram_index_name(COLUMN_NAME) WITH PARSER ngram;

    e.g.
    ALTER TABLE users ADD FULLTEXT INDEX ngram_users_name(name) WITH PARSER ngram;
    ALTER TABLE users ADD FULLTEXT INDEX ngram_users_name(name) WITH PARSER ngram;

    SELECT u.*
    FROM users u
    WHERE MATCH(u.name) AGAINST("peter" IN BOOLEAN MODE)
  2. peterkimzz revised this gist Apr 25, 2019. 1 changed file with 4 additions and 1 deletion.
    5 changes: 4 additions & 1 deletion ngram.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1 +1,4 @@
    ALTER TABLE accounts ADD FULLTEXT INDEX ngram_subjects(subjects) WITH PARSER ngram;
    ALTER TABLE TABLE_NAME ADD FULLTEXT INDEX ngram_index_name(COLUMN_NAME) WITH PARSER ngram;

    e.g.
    ALTER TABLE users ADD FULLTEXT INDEX ngram_users_name(name) WITH PARSER ngram;
  3. peterkimzz revised this gist Apr 25, 2019. 1 changed file with 0 additions and 2 deletions.
    2 changes: 0 additions & 2 deletions ngram.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,3 +1 @@
    ```
    ALTER TABLE accounts ADD FULLTEXT INDEX ngram_subjects(subjects) WITH PARSER ngram;
    ```
  4. peterkimzz created this gist Apr 25, 2019.
    3 changes: 3 additions & 0 deletions ngram.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,3 @@
    ```
    ALTER TABLE accounts ADD FULLTEXT INDEX ngram_subjects(subjects) WITH PARSER ngram;
    ```