MySQL Tutorial/Data Types/FULLTEXT

FULLTEXT

   <source lang="sql">

mysql> mysql> CREATE TABLE myTable

   -> (
   ->    OrderID SMALLINT UNSIGNED NOT NULL,
   ->    ModelID SMALLINT UNSIGNED NOT NULL,
   ->    Name VARCHAR(40),
   ->    PRIMARY KEY (OrderID),
   ->    FULLTEXT (Name)
   -> );

Query OK, 0 rows affected (0.05 sec) mysql> mysql> desc myTable; +---------+----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------+----------------------+------+-----+---------+-------+ | OrderID | smallint(5) unsigned | NO | PRI | | | | ModelID | smallint(5) unsigned | NO | | | | | Name | varchar(40) | YES | MUL | NULL | | +---------+----------------------+------+-----+---------+-------+ 3 rows in set (0.00 sec) mysql> mysql> drop table myTable; Query OK, 0 rows affected (0.00 sec) mysql> mysql></source>