Hello.
At first: from your phrase with default values for the FULLTEXT
parameters there is the only one meaningful word - football.
Because 'I', 'on', 'TV' has less than 3 characters. 'like' is
in the stopword list. Quotes '"' - are skipped from the search.
What query do you use to search? Does my example work on your system:
mysql> select * from ft where match(a) against('I "football" on TV');
+-------------------------+
| a |
+-------------------------+
| I like "football" on TV |
+-------------------------+
CREATE TABLE `ft` (
`a` text,
FULLTEXT KEY `a` (`a`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
mysql> select * from ft ;
+----------------------------------+
| a |
+----------------------------------+
| clear manual |
| greate manual |
| caa0b1661f71f8c9395e2ab87a6f5245 |
| f99b66713ee69d05f153cc78846686f5 |
| 6a86aa82e04244a73f2139021d5fc723 |
| 6a86aa82e04244a73f2139021d5fc723 |
| 6a86aa82e04244a73f2139021d5fc723 |
| e5c26cd3db77db54fa3d98bfcca2d019 |
| e5c26cd3db77db54fa3d98bfcca2d019 |
| e5c26cd3db77db54fa3d98bfcca2d019 |
| e5c26cd3db77db54fa3d98bfcca2d019 |
| b9d9fe513c50cc9d3a391bc6d3ccc10d |
| b9d9fe513c50cc9d3a391bc6d3ccc10d |
| I like "football" on TV |
+----------------------------------+
HMax <[EMAIL PROTECTED]> wrote:
> Hi list,
>
> I'm trying to figure out how to use the exact phrase search in
> fulltext boolean mode when the phease to search includes double
> quotes.
>
> For instance, what if I want to search this exact phrase :
> I like "football" on TV
>
> I think I've tried all the solution I'm aware of without any results.
> Any help would be appreciated!
>
> Thanks
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [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]
