MySQL Forums
Forum List  »  Full-Text Search

Re: No records shown when more than one result
Posted by: Jay Alverson
Date: February 25, 2009 09:26AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: No records shown when more than one result
3798
February 25, 2009 09:26AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.