I get nothing. Must be doing something wrong...
v5.0.67
mysql>
mysql> use test;
Database changed
mysql>
mysql> drop table if exists fts;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> create table fts (line text, fulltext (line));
Query OK, 0 rows affected (0.08 sec)
mysql>
mysql> insert into fts values
-> ("<p>My investment in a global barndance program continues, <p>The Inner Zone provides a source of team information, press releases and sponsorship"),
-> ("<p>My investment in a global barndance program continues, <p>The Inner Zone provides a source of team information, releases sponsorship"),
-> ("<p>My investment in a global barndance program continues, <p>The Inner Zone provides a source of team information, press releases and");
Query OK, 3 rows affected (0.00 sec)
Records: 3 Duplicates: 0 Warnings: 0
mysql>
mysql> select * from fts;
+---------------------------------------------------------------------------------------------------------------------------------------------------+
| line |
+---------------------------------------------------------------------------------------------------------------------------------------------------+
| <p>My investment in a global barndance program continues, <p>The Inner Zone provides a source of team information, press releases and sponsorship |
| <p>My investment in a global barndance program continues, <p>The Inner Zone provides a source of team information, releases sponsorship |
| <p>My investment in a global barndance program continues, <p>The Inner Zone provides a source of team information, press releases and |
+---------------------------------------------------------------------------------------------------------------------------------------------------+
3 rows in set (0.00 sec)
mysql>
mysql> SELECT * from fts where match (line) against("sponsorship");
Empty set (0.00 sec)
mysql>
mysql> drop table if exists fts;
Query OK, 0 rows affected (0.00 sec)
mysql>
mysql> create table fts (line text, fulltext (line));
Query OK, 0 rows affected (0.06 sec)
mysql>
mysql> insert into fts values
-> ("<p>My investment in a global barndance program continues, <p>The Inner Zone provides a source of team information, press releases and sponsorship"),
-> #("<p>My investment in a global barndance program continues, <p>The Inner Zone provides a source of team information, releases sponsorship"),
-> ("<p>My investment in a global barndance program continues, <p>The Inner Zone provides a source of team information, press releases and");
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql>
mysql> select * from fts;
+---------------------------------------------------------------------------------------------------------------------------------------------------+
| line |
+---------------------------------------------------------------------------------------------------------------------------------------------------+
| <p>My investment in a global barndance program continues, <p>The Inner Zone provides a source of team information, press releases and sponsorship |
| <p>My investment in a global barndance program continues, <p>The Inner Zone provides a source of team information, press releases and |
+---------------------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)
mysql>
mysql> SELECT * from fts where match (line) against("sponsorship");
Empty set (0.00 sec)
mysql>
mysql> SELECT * from fts where match (line) against("press");
Empty set (0.00 sec)
mysql>
mysql> notee
>
Thanks, Jay