Tag: SQLite3
$ CPPFLAGS="-DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS4_PARENTHESIS" ./configure $ make $ sudo make install
rails db
.tables
.schema テーブル名
INSERT INTO books values(NULL, '本1', '著者1', '本の内容1', '2016-05-14 10:00:01', '2016-05-14 10:00:01'); INSERT INTO books values(NULL, '本2', '著者2', '本の内容2', '2016-05-14 10:00:01', '2016-05-14 10:00:01'); INSERT INTO books values(NULL, '本3', '著者3', '本の内容3', '2016-05-14 10:00:01', '2016-05-14 10:00:01');
sqlite test.sqlite3 < insert.sql
CREATE VIRTUAL TABLE tbl USING fts3(sentence, words);
SELECT sentence FROM tbl WHERE words MATCH '今日';