Hi!
On Oct 13, Alan wrote:
mysql> select title from content where match
(title,center_content,right_content) against ('updates');
+-----------------------------+
| title |
+-----------------------------+
| eXI Systems' Latest Updates |
+-----------------------------+
1 row in set (0.00 sec)
But when I try to match on 'exi', I get:
mysql> select title from content where match
(title,center_content,right_content) against ('exi');
Empty set (0.00 sec)
Try MATCH ... AGAINST (... IN BOOLEAN MODE).
If it'll work - it means that the word is present in more than 50% of
rows. See the manual about 50% threshold.
Regards,
Sergei
5 messages in com.mysql.lists.mysqlRe: full-text search problems (newbie)
