Performing Phrase Searches with a FULLTEXT Index

    
mysql>
mysql> CREATE TABLE mytable
    -> (
    ->     bsect ENUM('O','N') NOT NULL, # book section (testament)
    ->     bname VARCHAR(20) NOT NULL, # book name
    ->     bnum TINYINT UNSIGNED NOT NULL, # book number
    ->     cnum TINYINT UNSIGNED NOT NULL, # chapter number
    ->     vnum TINYINT UNSIGNED NOT NULL, # verse number
    ->     vtext TEXT NOT NULL # text of verse
    -> ) TYPE = MyISAM;
Query OK, 0 rows affected, 1 warning (0.00 sec)

mysql>
mysql> ALTER TABLE mytable ADD FULLTEXT (vtext);
Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

mysql>
mysql> SELECT COUNT(*) FROM mytable WHERE MATCH(vtext) AGAINST('still small voice');
+----------+
| COUNT(*) |
+----------+
|        0 |
+----------+
1 row in set (0.00 sec)

mysql>
mysql> drop table mytable;
Query OK, 0 rows affected (0.00 sec)

Related examples in the same category

1.	Alter table to add a fulltext index
2.	FULLTEXT search index
3.	Create a fulltext index on the combination of TITLE and SUMMARY.
4.	Using fulltext index
5.	Creating a Full-Text Index

Performing Phrase Searches with a FULLTEXT Index : Index « FullText Search « SQL / MySQL

Related examples in the same category