"m n" <[EMAIL PROTECTED]> wrote:
> How fulltext is working!!?
>From the MySQL manual:
The search for the word MySQL produces no results in the above example, because that
word is present in more than half the rows. As such, it is effectively treated as a
stopword (that is, a word with zero semantic value). This is the most desirable
behaviour -- a natural language query should not return every second row from a 1 GB
table.
You can read more about full-test search at:
http://www.mysql.com/doc/en/Fulltext_Search.html
>
> I have the following table with just one record! And when I do a select
> statement, mysql returns no hits!!!
>
> Would you explain to me what is wrong??
>
> Tanks
> Cheers!
>
> Adam
>
> CREATE TABLE `mytest` (
> `id` int(11) NOT NULL default '0',
> `sub` text,
> PRIMARY KEY (`id`),
> FULLTEXT KEY `sub` (`sub`)
> ) TYPE=MyISAM;
>
> INSERT INTO `mytest` VALUES (0, 'my name is kalle and i live in the
> North');
>
> SELECT * FROM `mytest` WHERE (MATCH (sub) against ("my"));
>
> Not hists!!!???
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
