Alright, my example phrase wasn't a good one. Let's try this now:
We have a table with company activities.
On of them is :
"Plastique ou carton" and some others are in "Plastic, carton"
Plastique <> Plastic (different language)
What we want, is to find exactly "Plastique ou carton" and not the other ones.
So here are some requests:
â This first one obviously returns one good result:
SELECT *
FROM `tbltopic`
where match (title) AGAINST ('+plastique +ou +carton' in boolean mode)
â This second one too :
SELECT *
FROM `tbltopic`
where match (title) AGAINST ('"plastique ou carton"' in boolean mode)
â Now suppose that in my table, "plastique ou carton" are between
double quotes. I have a search engine in which users can enter an
exact phrase search. So in my code I insert this phrase they want to
find between double quotes in my fulltext search, just as in example
2. But what if they want to find "plastique ou carton" ?
â If the value of my field is :
Fabrication de "Plastique ou carton"
and I want to search for this exact phrase, including double quotes,
what should my request be ?
Thanks !
CheHax
On Fri, 25 Feb 2005 16:32:33 +0200, Gleb Paharenko
<[EMAIL PROTECTED]> wrote:
> 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]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
