讓我們首先創建一個表-mysql>?create?table?DemoTable1833

(

Name?varchar(20)

);

修改表-Mysql>?alter?table?DemoTable1833?ADD?FULLTEXT(Name);

Records:?0??Duplicates:?0??Warnings:?1

使用插入命令在表中插入一些記錄-mysql>?insert?into?DemoTable1833?values('John?Doe');

mysql>?insert?into?DemoTable1833?values('Adam?Smith');

mysql>?insert?into?DemoTable1833?values('Chris?Brown');

mysql>?insert?into?DemoTable1833?values('John?Smith');

使用select語句顯示表中的所有記錄-mysql>?select?*?from?DemoTable1833;

這將產生以下輸出-+-------------+

|?Name????????|

+-------------+

|?John?Doe????|

|?Adam?Smith??|

|?Chris?Brown?|

|?John?Smith??|

+-------------+

4?rows?in?set?(0.00?sec)

這是查詢以選擇在特定列中包含字符串的行mysql>?select?*?from?DemoTable1833?where?MATCH(Name)?AGAINST('+John?Smith+')?;

這將產生以下輸出-+------------+

|?Name???????|

+------------+

|?John?Smith?|

|?John?Doe???|

|?Adam?Smith?|

+------------+

3?rows?in?set?(0.00?sec)