Re: FULLTEXT Exact phrase search including quotes
Hello.
>and I want to search for this exact phrase, including double quotes,
You can't do this, because fulltext search operates with "words",
and double quotes not a "word". Also an order of the sequence of
words doesn't have a sence for a fulltext search.
CheHax <[EMAIL PROTECTED]> wrote:
> 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 on=
> es.
>
> So here are some requests:
>
> =E2=80=A2 This first one obviously returns one good result:
> SELECT *
> FROM `tbltopic`
> where match (title) AGAINST ('+plastique +ou +carton' in boolean mode)
>
> =E2=80=A2 This second one too :
> SELECT *
> FROM `tbltopic`
> where match (title) AGAINST ('"plastique ou carton"' in boolean mode)
>
> =E2=80=A2 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" ?
>
> =E2=80=A2 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.
>>=20
>> At first: from your phrase with default values for the FULLTEXT
>>=20
>> parameters there is the only one meaningful word - football.
>>=20
>> Because 'I', 'on', 'TV' has less than 3 characters. 'like' is
>>=20
>> in the stopword list. Quotes '"' - are skipped from the search.
>>=20
>> What query do you use to search? Does my example work on your system:
>>=20
>> mysql> select * from ft where match(a) against('I "football" on TV');
>>=20
>> +-+
>>=20
>> | a |
>>=20
>> +-+
>>=20
>> | I like "football" on TV |
>>=20
>> +-+
>>=20
>> CREATE TABLE `ft` (
>>=20
>> `a` text,
>>=20
>>FULLTEXT KEY `a` (`a`)
>>=20
>>) ENGINE=3DMyISAM DEFAULT CHARSET=3Dutf8
>>=20
>> mysql> select * from ft ;
>>=20
>> +--+
>>=20
>> | a|
>>=20
>> +--+
>>=20
>> | clear manual |
>>=20
>> | greate manual|
>>=20
>> | caa0b1661f71f8c9395e2ab87a6f5245 |
>>=20
>> | f99b66713ee69d05f153cc78846686f5 |
>>=20
>> | 6a86aa82e04244a73f2139021d5fc723 |
>>=20
>> | 6a86aa82e04244a73f2139021d5fc723 |
>>=20
>> | 6a86aa82e04244a73f2139021d5fc723 |
>>=20
>> | e5c26cd3db77db54fa3d98bfcca2d019 |
>>=20
>> | e5c26cd3db77db54fa3d98bfcca2d019 |
>>=20
>> | e5c26cd3db77db54fa3d98bfcca2d019 |
>>=20
>> | e5c26cd3db77db54fa3d98bfcca2d019 |
>>=20
>> | b9d9fe513c50cc9d3a391bc6d3ccc10d |
>>=20
>> | b9d9fe513c50cc9d3a391bc6d3ccc10d |
>>=20
>> | I like "football" on TV |
>>=20
>> +--+
>>=20
>>=20
>> HMax <[EMAIL PROTECTED]> wrote:
>>=20
>> > Hi list,
>>=20
>> >
>>=20
>> > I'm trying to figure out how to use the exact phrase search in
>>=20
>> > fulltext boolean mode when the phease to search includes double
>>=20
>> > quotes.
>>=20
>> >
>>=20
>> > For instance, what if I want to search this exact phrase :
>>=20
>> > I like "football" on TV
>>=20
>> >
>>=20
>> > I think I've tried all the solution I'm aware of without any results.
>>=20
>> > Any help would be appreciated!
>>=20
>> >
>>=20
>> > Thanks
>>=20
>> >
>>=20
>> --
>> For technical support contracts, goto https://order.mysql.com/?ref=3Densi=
> ta
>> This email is sponsored by Ensita.NET http://www.ensita.net/
>> __ ___ ___ __
>> / |/ /_ __/ __/ __ \/ /Gleb Paharenko
>> / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
>> /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
>> <___/ www.mysql.com
>>=20
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>>=20
>>
>
--
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]
Re: FULLTEXT Exact phrase search including quotes
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]
Re: FULLTEXT Exact phrase search including quotes
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]
FULLTEXT Exact phrase search including quotes
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 -- HMax -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
