Skip to content

Instantly share code, notes, and snippets.

@stevenschlansker
Created December 30, 2015 05:01
Show Gist options
  • Save stevenschlansker/2eb008e3adeeb7f09b31 to your computer and use it in GitHub Desktop.
Save stevenschlansker/2eb008e3adeeb7f09b31 to your computer and use it in GitHub Desktop.
sqlite> CREATE VIRTUAL TABLE tokens1 USING fts3tokenize(simple,en_US);
sqlite> SELECT * FROM tokens1 WHERE input='song_0';
input|token|start|end|position
song_0|song|0|4|0
song_0|0|5|6|1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment