Hi,
I'm sure this must've been done before, so if someone can point me at a
discussion or assist me in some other way I'd appreciate it.
If I'm browsing a paged list of invoices say in numerical order and I
then want to reposition the list on a certain client, I can do a second
query to the
[snip]
Given a search string of 'NA&SD' my default Fulltext search doesn't find it.
Wondered why?
[/snip]
Quote from 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 true word characters (letters, digits
Given a search string of 'NA&SD' my default Fulltext search doesn't find
it. Wondered why? Is there a fix? Thanks for the help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Given a search string of 'NA&SD' my default Fulltext search doesn't find
it. Wondered why? Is there a fix? Thanks for the help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
GH schrieb:
Laura did this work... inquiring minds want to know :)
Laura:
Perhaps the "-" is acting like a Boolean operator. What if you put
double quotes around your search phrase:
SELECT * FROM metadata WHERE MATCH( type ) AGAINST ( '+"XY-11443"' IN
BOOLEAN MODE );
Or.. the - is possibly suppose
Laura did this work... inquiring minds want to know :)
On Wed, 29 Sep 2004 13:36:40 -0400, Wesley Furgiuele
<[EMAIL PROTECTED]> wrote:
> Laura:
>
> Perhaps the "-" is acting like a Boolean operator. What if you put
> double quotes around your search phrase:
>
> SELECT * FROM metadata WHERE MATC
Laura:
Perhaps the "-" is acting like a Boolean operator. What if you put
double quotes around your search phrase:
SELECT * FROM metadata WHERE MATCH( type ) AGAINST ( '+"XY-11443"' IN
BOOLEAN MODE );
Wes
On Wed, 29 Sep 2004 13:22:54 -0400, Laura Scott <[EMAIL PROTECTED]> wrote:
>
>
> Hello,
Hello,
I have a questions with limitations/restrictions that are around for
full text search.
I have a field with data like "XY-11443;." and I need to find the
record. The original developer was using full text search and says that
all was working before the task switched hands.
The basic
Brent Baisley wrote:
Not as far as I know. Boolean forces all matches to have all the words
searched on, rather than relevance ranking the results based on how many
of the specified search words are in a record. Searching in boolean mode
will always return the same or less results than a regula
Not as far as I know. Boolean forces all matches to have all the words
searched on, rather than relevance ranking the results based on how
many of the specified search words are in a record. Searching in
boolean mode will always return the same or less results than a regular
full text search.
Brent Baisley wrote:
The other thing to consider is the 50% rule. If more than 50% of the
records match, the search is consider irrelevant and no records are
returned. So if you have 120 records and 61 have DB2 in them, you won't
get a result set.
But the 50% rule is overridden when the search
The other thing to consider is the 50% rule. If more than 50% of the
records match, the search is consider irrelevant and no records are
returned. So if you have 120 records and 61 have DB2 in them, you won't
get a result set.
On Mar 31, 2004, at 12:28 AM, Shane Allen wrote:
apologies, I forgo
Richard Davey wrote:
Hello Shane,
Wednesday, March 31, 2004, 5:43:10 AM, you wrote:
SA> using MATCH(description) AGAINST('+db2' IN BOOLEAN MODE) returns no results.
SA> Is this expected behaviour? If so, is there a way to circumvent it?
By default, the full text indexing engine doesn't include w
Hello Shane,
Wednesday, March 31, 2004, 5:43:10 AM, you wrote:
SA> using MATCH(description) AGAINST('+db2' IN BOOLEAN MODE) returns no results.
SA> Is this expected behaviour? If so, is there a way to circumvent it?
By default, the full text indexing engine doesn't include words with
less than 4
I have a table with the following:
CREATE TABLE foo (
...
description text,
...
FULLTEXT INDEX (description),
...
);
select count(*) from foo where description like '%db2%';
returns 61 rows. Checking them confirms that the "word" db2 exists as a
standalone word separated either by punctuation or
Since you are putting a wild card at the front of the phrase, indexes
can't be used. You definitely want to change that to a full text index
if you want to search on words or phrases contained in a field.
I use a full text search on a database with 15k records and growing.
Each record contains
Hi
I have a varchar field to search. There are 5k records.
I'm using: WHERE name LIKE '%outer banks%'
It seems to be very slow. I was reading about full text searches.
Maybe I could do something like: WHERE MATCH ('name') AGAINST ('outer
banks')
I'm looking for a quick way to search.
Does an
Meltem,
Tuesday, September 17, 2002, 11:33:56 AM, you wrote:
>> Is there any other efficient way (--except using LIKE)of searching a
MD> keyword
>> in mysql ...
REGEXP, full-text search depends on what you need. Why don't you like
'LIKE'?
http://www.mysql.com/doc/en/Pattern_matching.html
FULLTEXT index, look in http://www.mysql.com/manual.php
Jannes Faber
- Original Message -
From: "Meltem Demirkus" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 17, 2002 10:33 AM
Subject: search question
>
>
> > Hi,
&g
> Hi,
> Is there any other efficient way (--except using LIKE)of searching a
keyword
> in mysql ...
>
> thanks
>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Hi,
Is there any other efficient way (--except using LIKE)of searching a keyword
in mysql ...
thanks
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the li
I am currently working on a website that is implemented using PHP and MySQL.
The site currently has a simple search engine that allows a shopper to type
in a search string that is stored in $search. For example, if a shopper
types in 1972 Ford Mustang
$string ="1972 Ford Mustang"
Using the follo
ww.mysql.com/doc/F/u/Fulltext_Fine-tuning.html
>
>
>
>
>-Original Message-
>From: Dan Tappin [mailto:[EMAIL PROTECTED]]
>Sent: Monday, March 25, 2002 10:03 AM
>To: [EMAIL PROTECTED]
>Cc: [EMAIL PROTECTED]
>Subject: Re: Dumb Newbie Keyword Search Question
>
>
, 2002 10:03 AM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Dumb Newbie Keyword Search Question
Thanks Alec,
That is exactly what I was looking for.
Dan
> I think what you want is a FULLTEXT index with the MATCH operator - see
> http://www.mysql.com/doc/F/u/Fulltext_Searc
Thanks Alec,
That is exactly what I was looking for.
Dan
> I think what you want is a FULLTEXT index with the MATCH operator - see
> http://www.mysql.com/doc/F/u/Fulltext_Search.html .
>
> Particularl.y, see the new developments in fulltext in V4.0.1 half way doen
> the page
>
>Alec Cawle
I have been looking through the mailing list archives but I can seem to find
a straight forward answer anywhere.
I have a MySQL table with a variety of text columns I would like to search.
Pretty basic... A web search form returning the users input $keywords.
Some type of relevance system would
Hi!
On Oct 25, Lowell Allen wrote:
> Thanks for the reply, Sergei. I think I've since found the problem in the
> MySQL documentation -- under "Fulltext restrictions", 6.8.1, "All parameters
> to the MATCH function must be columns from the same table that is part of
> the same fulltext index." I n
Hi!
On Oct 24, Lowell Allen wrote:
> I'm trying to do a search against two fulltext indexes. I can successfully
> search against either one separately, like:
>
> $psl->set_query("SELECT Products.ID, Products.Name, " .
> "Products.Photo, Products.Description " .
> "FROM Products, Cate
I'm trying to do a search against two fulltext indexes. I can successfully
search against either one separately, like:
$psl->set_query("SELECT Products.ID, Products.Name, " .
"Products.Photo, Products.Description " .
"FROM Products, Categories, ProductsCategories " .
"WHERE Catego
Hi!
On Apr 03, Oson, Chris M. wrote:
> Hello,
>
> I have a site that I'm trying to implement a search engine on existing and
> archived news stories on a medium text datatype in a database.
>
> I read the documentation and got it running, but unless I missed something
> it's not doing what I
Oson take a look at mysql documentantion. You can do this with match
against.
A IR system is somewhat different than a DB. But mysql is both an IR and
a DB.
Oson, Chris M. wrote:
> Hello,
>
> I have a site that I'm trying to implement a search engine on existing and
> archived news stories o
My apologies, I didn't clarify that I *was* using a full-text search.
-Original Message-
From: Lindsay Adams [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, April 03, 2001 11:52 AM
To: [EMAIL PROTECTED]
Subject: Re: Full Text Search Question
To do a full word match like you are wanting
To do a full word match like you are wanting, you would need to break up the
sql query to do this:
... WHERE field LIKE "%word1%" AND field LIKE "%word2%" ...
That is how you have to do it if you are not using one of the latest 3.23
versions of mysql. If you have a newer version of mysql, check
Hello,
I have a site that I'm trying to implement a search engine on existing and
archived news stories on a medium text datatype in a database.
I read the documentation and got it running, but unless I missed something
it's not doing what I want it to do.
For example, if I put in the keyword
34 matches
Mail list logo
