Paul DuBois wrote:
At 10:49 +0100 11/8/05, Jigal van Hemert wrote:
Lindsey wrote:
but do you know how to use the * in regexp searches. err what i mean
if i want to search for * and not use it as asterix?
To use a literal instance of a special character in a regular
expression, precede it by
At 10:49 +0100 11/8/05, Jigal van Hemert wrote:
Lindsey wrote:
ok thanks, then i know!
but do you know how to use the * in regexp searches. err what i
mean if i want to search for * and not use it as asterix?
i have tried \* but that did't work, it just does the same as *.
The manual comes
Lindsey wrote:
Lets say the table contains the following brands
SAMSUNG
SIEMENS
SONY
If you do a fulltext boolean search with the term:
-S*Y
-(S*Y)
everyting that starts with an S will be excluded... any solutions?
Although I couldn't find a question in your post, I guess you want to
know
contains the following brands
SAMSUNG
SIEMENS
SONY
If you do a fulltext boolean search with the term:
-S*Y
-(S*Y)
everyting that starts with an S will be excluded... any solutions?
Although I couldn't find a question in your post, I guess you want to
know how to find
Lindsey wrote:
ok thanks, then i know!
but do you know how to use the * in regexp searches. err what i mean if i want
to search for * and not use it as asterix?
i have tried \* but that did't work, it just does the same as *.
The manual comes again to the rescue ;-)
Appendix G [1] tells
Lets say the table contains the following brands
SAMSUNG
SIEMENS
SONY
If you do a fulltext boolean search with the term:
-S*Y
-(S*Y)
everyting that starts with an S will be excluded... any solutions?
-S*Y will return all.
-
FREE E-MAIL IN 1
Hi!
Check the manual for ft_boolean_syntax variable.
It defines what character is used for every operator.
Space marks default operator - so you can change it.
On Jun 06, Sebastian wrote:
I created a search app with fulltext, boolean, etc. i have two forms,
one that allows the user to just
I created a search app with fulltext, boolean, etc. i have two forms,
one that allows the user to just enter a basic search in a single input
field and a more advanced form with additional input areas for advanced
boolean searches.. now, when you do not specify a boolean operator, what
does it
If I search on:
BT-1034.06
I get returned:
BT-1034.02
BT-1034.03
BT-1034.05
...
BT-1034.11
If I put in ie. BT-1034.06
I only get BT-1034.06 returned.
The BT- part seems irrelevant.
But I don't understand the results.
Why so many returned? Seems like 1034.06
w/out the is unique enough. Is '.' a
From the manual http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html:
MySQL uses a very simple parser to split text into words. A word is any
sequence of characters consisting of letters, digits, ', or _. Some
words are ignored in full-text searches:
Any word that is too short is ignored...
.
[EMAIL PROTECTED] said:
From the manual
http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html:
MySQL uses a very simple parser to split text into words. A word is any
sequence of characters consisting of letters, digits, ', or _. Some
words are ignored in full-text searches:
Any
leegold wrote:
[EMAIL PROTECTED] said:
From the manual
http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html:
MySQL uses a very simple parser to split text into words. A word is any
sequence of characters consisting of letters, digits, ', or _. Some
words are ignored in full-text searches:
Any
12 matches
Mail list logo