i have a table with a FULLTEXT index that correctly matches certain words:
mysql> select title from movie where title like 'little%';
+------------------------+
| title |
+------------------------+
| Little Fugitive |
| Little Kidnappers, The |
| Little Mermaid, The |
| Little Thief, The |
+------------------------+
4 rows in set (0.00 sec)
mysql> select title from movie where match(movie.title, movie.subtitle)
against('little');
Empty set (0.00 sec)
but fails to match others:
mysql> select title from movie where title like '%fugitive%';
+-----------------+
| title |
+-----------------+
| Little Fugitive |
+-----------------+
1 row in set (0.00 sec)
mysql> select title from movie where match(movie.title, movie.subtitle)
against('fugitive');
+-----------------+
| title |
+-----------------+
| Little Fugitive |
+-----------------+
1 row in set (0.00 sec)
does anyone know what this would happen?
john
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php