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]
