Thanks for your patient reply.
Now I believe that the memory leak problem was generated by the program.
On Sat, Nov 1, 2008 at 5:31 PM, Ian Christian [EMAIL PROTECTED] wrote:
2008/10/31 Moon's Father [EMAIL PROTECTED]
*A prepared statement is also global to the connection. If you create a
2008/10/31 Moon's Father [EMAIL PROTECTED]
*A prepared statement is also global to the connection. If you create a
prepared statement within a stored routine, it is not deallocated when the
stored routine ends. *
Then I don't know how to deallocate the memory used by prepare statement
]
Sent: Thursday, October 12, 2006 2:58 PM
Subject: Re: boolean search on phrase
Hello:
I may be going out on a limb, as I missed part of the thread;
nevertheless, have you tried regular expressions?
As in REGEXP 'oils?' where the ? matches zero or one of the previous
characters. (or REGEXP 'oils
Hi All,
I want a boolean search on a phrase.
For example on olive oil, but it should return also olive oils etc.
Now I use the following:
SELECT Description FROM products
WHERE MATCH (Description ) AGAINST('olive oil' IN BOOLEAN MODE);
This works fine, but it does NOT return rows with olive oils
Hi
The Boolen Search will itself satisfy your query. If you enclose the phrase
within double quote (''), then the characters matches only rows that contain
the phrase literally, as it was typed.
Try removing quotes.
Thanks
ViSolve DB Team.
- Original Message -
From: C.R.Vegelin
AM
Subject: Re: boolean search on phrase*
Hi
The Boolen Search will itself satisfy your query. If you enclose the phrase
within double quote (''), then the characters matches only rows that contain
the phrase literally, as it was typed.
Try removing quotes.
Thanks
ViSolve DB Team
, October 12, 2006 4:08 PM
Subject: Re: boolean search on phrase*
Thanks ViSolve,
So far I have tried the next alternatives, not giving me what I need:
a) ... MATCH (Description) AGAINST('olive oil' IN BOOLEAN MODE)
giving only olive oil but not olive oils
b) ... MATCH (Description) AGAINST('olive
]
To: C.R.Vegelin [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Thursday, October 12, 2006 11:05 AM
Subject: Re: boolean search on phrase*
Hi,
Try with + and * fulltext boolean operators.
For instance,
MATCH (Description) AGAINST('+olive oil*' IN BOOLEAN MODE)
Thanks,
ViSolve DB Team.
- Original
on phrase*
Hi
The Boolen Search will itself satisfy your query. If you
enclose the phrase within double quote (''), then the
characters matches only rows that contain the phrase
literally, as it was typed.
Try removing quotes.
Thanks
ViSolve DB Team.
- Original Message -
From
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
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
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
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
Sergei, but this is a phrase search. The original query is:
match (keywords) against ('16-bit Touch' IN BOOLEAN MODE)
So shouldn't all words that are actually searched on be present
in a particular order?
Bill
Sergei Golubchik wrote:
Hi!
On Feb 27, Haitao Jiang wrote:
Thanks
Hi!
On Mar 01, William Au wrote:
Sergei, but this is a phrase search. The original query is:
match (keywords) against ('16-bit Touch' IN BOOLEAN MODE)
So shouldn't all words that are actually searched on be present
in a particular order?
Ok, sorry.
If the original query is '16-bit Touch
Could anyone explain why
match (keywords) against ('16-bit Touch' IN BOOLEAN
MODE)
returns results, but not
match (keywords) against ('16-bit' IN BOOLEAN MODE)?
Is it a known bug?
Thanks a lot!
Haitao
__
Do you Yahoo!?
Get better spam protection with
It's expected behavior, not a bug.
16-bit Touch is parsed as 16, bit and touch. The first two are
ignored because they are too short. So, this searches for rows with
touch, then selects the ones which contain your phrase.
16-bit contains no words to search for, so it returns nothing
, not a bug.
16-bit Touch is parsed as 16, bit and touch.
The first two are
ignored because they are too short. So, this
searches for rows with
touch, then selects the ones which contain your
phrase.
16-bit contains no words to search for, so it
returns nothing.
Michael
Haitao
Hi!
On Feb 27, Haitao Jiang wrote:
Thanks! That was what I guessed. But how to explain
16-bit Touch doesn't match records with 32-bit
Touch in the keywords? It just returned all the
records with 16-bit Touch, i.e. 16-bit seems does
count.
Because the presense of 16-bit substring is
the
asterisk should appear inside or outside the quotes. I have tried both techniques
experimentally and found that
DH neither work correctly!
Currently phrase search doesn't work with operators, it's in the TODO
list. If somebody think that it works for him - it's a bug :)
DH When you put the asterisk
Hi!
On Aug 08, Dan Nelson wrote:
In the last episode (Aug 08), Christopher Book said:
Using mysql 4.0.2 I get the following behaviour (phrase searching):
match (field) against ('pack of' in boolean mode)
gives me all results with 'pack of', not just 'pack'. So MySQL isn't
Hi,
Using mysql 4.0.2 I get the following behaviour (phrase searching):
match (field) against ('pack of' in boolean mode)
gives me all results with 'pack of', not just 'pack'. So MySQL isn't
ignoring 'of' even though the word is too short to normally be considered.
However if I use: match
In the last episode (Aug 08), Christopher Book said:
Using mysql 4.0.2 I get the following behaviour (phrase searching):
match (field) against ('pack of' in boolean mode)
gives me all results with 'pack of', not just 'pack'. So MySQL isn't
ignoring 'of' even though the word is too
The MATCH syntax will return a number indicating the relevance of a
particular record to the specified criteria. I would like to generate
similar numbers for phrase searches... please read on.
I have written code which will generate an SQL query that allows phrase
searching (without using
Hello
I have a question,
is possible to search on mysql 4.0 in fulltext index
the exact phrase ?
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com
On Wed, May 29, 2002 at 02:10:07PM -0700, ddd wrote:
I have a question, is possible to search on mysql 4.0 in fulltext
index the exact phrase ?
http://www.mysql.com/doc/F/u/Fulltext_Search.html suggests that it is
possible. Here is the relevant excerpt:
The boolean full-text search capability
ddd,
Thursday, May 30, 2002, 12:10:07 AM, you wrote:
d I have a question,
d is possible to search on mysql 4.0 in fulltext index
d the exact phrase ?
Phrase search will come in 4.0.2...
d thanks
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email
MATCH (Term) AGAINST ('search phrase') AND
Term LIKE '%search phrase%'
This, in my experience, appears to be nearly as fast (in perceived terms) as
the straight full text search because the LIKE criterion, whilst slow on
large databases if used with a % wildcard at the beginning (which prevents
Hello!
I've been using MySQL version 3.22.32 and query with AND NOT phrase worked
fine. Now I have MySQL version 3.23.36 and the same query is losing records.
(the same data).
The query is quite complicated:
SELECT * FROM docs LEFT OUTER JOIN typy ON docs.nr = typy.nr LEFT
OUTER JOIN
I read through the MySQL documentation on full text indexing, and there
does not seem to be a way to search for a *phrase*, e.g. searching for
a document that contains "Sailor Moon", as opposed to one that contains
the word "Sailor" and the word "Moon", not neces
-
From: Philip Mak [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 5:39 PM
To: [EMAIL PROTECTED]
Subject: Phrase based fulltext searching
I read through the MySQL documentation on full text indexing, and there
does not seem to be a way to search for a *phrase*, e.g. searching for
a document
31 matches
Mail list logo