Im trying to run a full text query on a two letter keyword 'K7'. I have
set ft_min_word_len=2 and restarted the server and if I view the system
vars in Mysql Workbench it shows it is set correctly.
I have then dropped and re-created the index on the descrip column. It
is an InnoDB table so I
]
Sent: Tuesday, July 02, 2013 10:21 AM
To: mysql@lists.mysql.com
Subject: Re: Full text search and sign as a part of the keyword
Hello,
(my response is not top-posted)
On 7/2/2013 12:50 PM, l...@afan.net wrote:
Another correction: Searching for Com, the test org is NOT gonna
Hi to all,
I have this full text search query
SELECT name, org_id,
address_id
FROM organization
WHERE org_active='Y' AND MATCH(name) AGAINST('ABC*' IN BOOLEAN
MODE)
and I'm not getting any results. And there IS a org ABC,
Inc.
My assumption is the ampersand sign as a part
no results at
all.
?!?
�
Hi to all,
I have this full text search query
SELECT name, org_id,
address_id
FROM organization
WHERE org_active='Y' AND MATCH(name) AGAINST('ABC*' IN
BOOLEAN
MODE)
and I'm not getting any results. And there IS a org ABC,
Inc.
My assumption is the ampersand
for Comp it's also gonna be shown.
But
Construction Company as well.
Then I changed the name of
the test org to ComMe.
Searching for Com, the test org is gonna be listed.
Though, Com no results at
all.
?!?
�
Hi to all,
I have this full text search
FULLTEXT (at least the MyISAM version) has 3 gotchas:
ft_min_word_len=4, stopwords, and the 50% rule
-Original Message-
From: shawn green [mailto:shawn.l.gr...@oracle.com]
Sent: Tuesday, July 02, 2013 10:21 AM
To: mysql@lists.mysql.com
Subject: Re: Full text search and sign
is gonna be listed.
Though, Com no results at
all.
?!?
�
Hi to all,
I have this full text search query
SELECT name, org_id,
address_id
FROM organization
WHERE org_active='Y' AND MATCH(name) AGAINST('ABC*' IN
BOOLEAN
MODE)
and I'm not getting any results
Practical Full-Text Search in MySQL
http://forge.mysql.com/wiki/Practical_Full-Text_Search_in_MySQL
This Thursday (December 3rd, 16:00 UTC – note the different time), Bill
Karwin will talk about Practical Full-Text Search in MySQL. He'll
introduce and compare five different approaches of full
Hi,
I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPARTMENT OF COMMERCE'.
When I did a search like the following;
SELECT COUNT(*) FROM
Hi,
I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPARTMENT OF COMMERCE'.
When I did a search like the following;
SELECT COUNT(*) FROM
Hi,
I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
ADMINISTRATION (NOAA), NATIONAL OCEAN SERVICE (NOS), DEPARTMENT OF COMMERCE'.
When I did a search like the following;
SELECT COUNT(*) FROM
'Words' shows in more than 50% rows will be regards as a stop words.
2009/4/24 mysupp...@asuma.com
Hi,
I've a table, 'article' which has a cloumn 'agency'with FULLTEXT (agency).
'agency' has six (6) rows of data: 'NATIONAL OCEANIC AND ATMOSPHERIC
ADMINISTRATION (NOAA), NATIONAL OCEAN
Sorry, I don't understand your answer. Could you kindly explain in more details?
Thanks,
Jack
--- On Fri, 4/24/09, zhu dingze mysql.li...@gmail.com wrote:
From: zhu dingze mysql.li...@gmail.com
Subject: Re: Full Text Search Problem
To: mysupp...@asuma.com
Cc: mysql
Hi,
When I use ft_min_word_len=3 under [mysqld] section, mysql fails to start.
ft_min_word_len=3 parameter has been added under [myisamchk] only , which
works.
mysql Ver 14.12 Distrib 5.0.67, for redhat-linux-gnu (i686) using readline
5.1
Anyone know about this?
Hi all:
I read in mysql documentation that searches are case-insensitive by
default but this default behaviour can be changed using a latin1_bin
collation. But, is there any way to make searches sensitive or
unsensitive to accents, umlauts, etc.?
I suppose that queries are accent sensitive by
MySQL has no idea how you are presenting the data (html, rtf, etc.),
so it couldn't hilight the words for you. It should really be that
tricky using grep and PHP.
Brent
I have my data as pure text: no html, rtf or something else. That is, one
table with two columns: one for the document id
Hi all:
I was reading documentation and searching into mail archives but I
didn't find a solution to the following question:
Is there any way to highligh results from a full-text search? I know
some tricky methods using PHP but I want to know if mysql (5.0 or 5.1
versions) offers some methos
into mail archives but I
didn't find a solution to the following question:
Is there any way to highligh results from a full-text search? I know
some tricky methods using PHP but I want to know if mysql (5.0 or 5.1
versions) offers some methos or function to do this.
I want to write the keywords
Dear Users,
I am facing a problem related to full text search. I am trying to
search non latin characters with no success :(.
I am trying the following queries for searching and only the English one works.
SELECT * FROM bangla_test WHERE MATCH(bn_test) AGAINST('নাম নাই' in
boolean mode)
SELECT
50% value or using default 50
%)
thanx and regards
--
View this message in context:
http://www.nabble.com/Full-Text-Search-tp14947073p14947073.html
Sent from the MySQL - General mailing list archive at Nabble.com.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Urms schrieb:
I'm using pretty standard approach to sorting search results by relevancy:
SELECT DISTINCT product_name,
MATCH (keywords) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN MODE) AS
rate
FROM _TT
WHERE MATCH ( keywords ) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN
MODE
Hello list
I have to make a full text search and I want to do it in many tables.
I have deferent tables for books authors and news.
Any ideas how to do it?
Thank you
Nikos
nikos schrieb:
Hello list
I have to make a full text search and I want to do it in many tables.
I have deferent tables for books authors and news.
Any ideas how to do it?
three separate queries or an UNION
--
Sebastian
--
MySQL General Mailing List
For list archives: http
On Jan 9, 2008 8:36 AM, Sebastian Mendel [EMAIL PROTECTED] wrote:
nikos schrieb:
Hello list
I have to make a full text search and I want to do it in many tables.
I have deferent tables for books authors and news.
Any ideas how to do it?
three separate queries or an UNION
Or a Boolean
That is a grate solution.
The problem is that I must have deferent links for each response.
That's the tricky thing!
Thank you
Sebastian Mendel wrote:
nikos schrieb:
Hello list
I have to make a full text search and I want to do it in many tables.
I have deferent tables for books authors
FROM News T1
WHERE TITLE like '%..whatever..' OR CONTENT like '%..whatever..'
Aloha!
Claudio Nanni
-Messaggio originale-
Da: nikos [mailto:[EMAIL PROTECTED]
Inviato: mercoledì 9 gennaio 2008 14.21
A: mysql@lists.mysql.com
Oggetto: full text search on multiple tables
Hello
Urms wrote:
I'm using pretty standard approach to sorting search results by relevancy:
SELECT DISTINCT product_name,
MATCH (keywords) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN MODE) AS
rate
FROM _TT
WHERE MATCH ( keywords ) AGAINST ('CONSOLIDATED* 16* bearing*' IN BOOLEAN
MODE ) 0
time it takes only about 0.006 sec without ORDER BY clause.
I understand that ORDER BY is time consuming but maybe someone knows a
different way to have sorting by relevancy.
Thanks in advance!
--
View this message in context:
http://www.nabble.com/Fast-relevance-sorting-of-full-text-search
mos schrieb:
I posted this message twice in the past 3 days, and it never gets on
the mailing list. Why?
Here it is again:
I have a Text field that contains paragraph text and for security
reasons I need to have it encrypted. If I do this, how can I still
implement full text search
I posted this message twice in the past 3 days, and it never gets on the
mailing list. Why?
Here it is again:
I have a Text field that contains paragraph text and for security reasons I
need to have it encrypted. If I do this, how can I still implement full
text search on it?
Also, I have
full
text search on it?
Also, I have a lot of Float columns that need to be protected but the user
has to use comparison operators like and on them. Any recommendations?
Hi,
This is quite a difficult one, and as usual in the field of security depends on
how valuable
the data is and how
. If I do this, how can I still implement full
text search on it?
Also, I have a lot of Float columns that need to be protected but the user
has to use comparison operators like and on them. Any
recommendations?
Hi,
This is quite a difficult one, and as usual in the field of security
[EMAIL PROTECTED] wrote:
mos wrote:
The data is quite valuable because there is a lot of competition in
this particular marketplace and my competitors would like to get their
hands on it. I've spent 5 years writing the software and generating
the data. Let's say for the sake of argument
mos wrote:
The data is quite valuable because there is a lot of competition in this
particular marketplace and my competitors would like to get their hands
on it. I've spent 5 years writing the software and generating the data.
Let's say for the sake of argument the data is worth $1
On 10/26/07, Baron Schwartz [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
mos wrote:
The data is quite valuable because there is a lot of competition in
this particular marketplace and my competitors would like to get their
hands on it. I've spent 5 years writing the software and
At 12:31 PM 10/26/2007, you wrote:
[EMAIL PROTECTED] wrote:
mos wrote:
The data is quite valuable because there is a lot of competition in this
particular marketplace and my competitors would like to get their hands
on it. I've spent 5 years writing the software and generating the data.
At 01:47 PM 10/26/2007, you wrote:
On 10/26/07, Baron Schwartz [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
mos wrote:
The data is quite valuable because there is a lot of competition in
this particular marketplace and my competitors would like to get their
hands on it. I've
: Baron Schwartz [EMAIL PROTECTED]
To: mos [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Friday, October 26, 2007 3:54:11 PM
Subject: Re: How to encrypt Text and still be able to use full text search?
3rd Attempt ++
I also need to protect a couple dozen Float fields and thought I
could
I also need to protect a couple dozen Float fields and thought I could
obscure them a bit by adding an offset to them based on an encrypted id
stored with each row. It is not going to be as good as encryption but
will help to obfuscate the data.
How much will obfuscation save you? Are you
to do full text search on some fields of some tables, but
I'm a bit
confused by the documentation. Questions:
a)How do I set that up (i.e. do I need to use a specific storage
engine for
a table)?
b)What storage engine(s) are required?
c)Are there any restrictions on mixing and matching
I'd like to do full text search on some fields of some tables, but I'm a bit
confused by the documentation. Questions:
a)How do I set that up?
b)What storage engines are required?
c)Are there any restrictions on mixing and matching tables?
d)Do table locking and transactions work the same
I'm sending this again, because the server seems to have been down for
several hours, and I'm not sure if it went out.
-
I'd like to do full text search on some fields of some tables, but I'm a bit
confused by the documentation. Questions:
a)How do I set that up (i.e. do I need to use
in error, please notify
the sender immediately by telephone or email and destroy the original
message without making a copy. Thank you.
- Original Message -
From: David T. Ashley [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Friday, July 06, 2007 9:19 PM
Subject: Full Text Search
David T. Ashley wrote:
I'm sending this again, because the server seems to have been down for
several hours, and I'm not sure if it went out.
Yes, I've been getting messages from yesterday, too. But I did get both
of your messages. I don't know what's up.
I'd like to do full text search
Dear list,
I'm programming a PHP-driven Search Engine for a newspaper.
Full-text Search with MyISAM Tables, MySQL 4.1.11, PHP 4.3.0
1GB of Text encoded by UTF-8
An average of 1Mbyte Data is inserted to database every day
A common SQL-Query:
SELECT COUNT(*) FROM news_archive
WHERE
MATCH
Hi!
I'm getting a lot of pushback on using mysql for full-text searching on over
30,000,000 documents. It's starting to slow down when using more than 10-15
keywords. Is there an alternative anyone is using?
I don't want to replace the database, but I do need to speed up the keyword
search.
You can tune the fulltext search in a few ways using the config, try
read up on the various server variables that has to do with fulltext
indexing. Other than that there is always the option of upgrading the
hardware :)
[EMAIL PROTECTED] wrote:
Hi!
I'm getting a lot of pushback on using
At 05:27 PM 8/2/2006, you wrote:
Hi!
I'm getting a lot of pushback on using mysql for full-text searching on
over 30,000,000 documents. It's starting to slow down when using more than
10-15 keywords. Is there an alternative anyone is using?
I don't want to replace the database, but I do
Best group member,
I have a problem. I was going to use FULL TEXT search for my Thai client. It
is working smooth with English text and wordings, the indexing and search
works fine.
The problem with Thai text is that words are not separated with a white
space as in English and other
Hi All,
I am using the MySQL full text search capability in the search workflow
in my appplication. I found that MySQL treats special character like
*./,* etc. as tokenizers if they are not specified within a
phrase(inside double quotes). For ex. If the search string entered is
M.B.A or 24/7
programming language.
Hope that gives you some ideas.
- Original Message -
From: Harini Raghavan [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, July 06, 2006 2:06 AM
Subject: special char in full-text search
Hi All,
I am using the MySQL full text search capability
I have 2 tables which have full text index on each of their columns.
Table 1 - forums_topics field - topic
Table 2 - forums_messages field - message
Is it possible to search them both in one query and determine which table
the result is being returned from in the search results?
Thanks
Maybe something like this:
select ft.topic, fm.message from forums_topics ft, forums_messages fm
match (ft.topic, fm.message) against (...)
if topic is null then the hit is from fm and vice versa... haven't tried
it, so might not work :)
Steffan A. Cline wrote:
I have 2 tables which have
Mark Steudel wrote:
I was doing a full text search and had a question on why two different
entries got the same score:
Here is my select statement
SELECT
id,
pubyear,
MATCH ( title ) AGAINST ( 'Nursing home federal requirements, guidelines to
surveyors, and survey protocols (MLM
Is there a way to escape the parenthesis?
-Original Message-
From: Gerald L. Clark [mailto:[EMAIL PROTECTED]
Sent: Friday, June 09, 2006 6:18 AM
To: Mark Steudel
Cc: mysql@lists.mysql.com
Subject: Re: Question on full text search scores, different content same
score
Mark Steudel wrote
...), five of which might contain
quite long lumps of text in TEXT fields (biographies, for instance),
the other four with shorter stuff in VARCHAR(127) fields. All these
fields have full text indices set up.
Searching for the word 'olympic', if I use the full text search -
match (...) against
I was doing a full text search and had a question on why two different
entries got the same score:
Here is my select statement
SELECT
id,
pubyear,
MATCH ( title ) AGAINST ( 'Nursing home federal requirements, guidelines to
surveyors, and survey protocols (MLM)' ) AS score,
title
FROM tblbook
Hi,
I've always done conventional searches Where ( title like '%$key1%')
or(isynopsis like '%$key2%')
etc etc
But the client has increased the complexity of the search and especially the
size of his database
and the search has really slowed. (particularly now that I have to search a
longtext
Hello.
Do I have to build an index first and how often is it updated etc?
Yes, you should create FULLTEXT indexes. However I'm not sure if you
will get any benefits for searching inner part of the words (*$key1*),
because you can search using asterisk only on the left-most prefixes of
Hi there,
I am facing problems with fulltext search on MySQL 4.0.18
Problem is, that words which are not seperated by space are not found.
Example:
A search for dsl will not find DSL-Modem
I looked it up on mysql.com help, but despite the fact that this is not
seperated by space and only 3
Merlin wrote:
Hi there,
I am facing problems with fulltext search on MySQL 4.0.18
Problem is, that words which are not seperated by space are not found.
Example:
A search for dsl will not find DSL-Modem
I looked it up on mysql.com help, but despite the fact that this is not
seperated by space
Merlin wrote:
Hi there,
I am facing problems with fulltext search on MySQL 4.0.18
Problem is, that words which are not seperated by space are not found.
Example:
A search for dsl will not find DSL-Modem
I looked it up on mysql.com help, but despite the fact that this is not
seperated by space
Hello.
Show us the query that fails, fulltext works ok here.
LIKE doesn't use fulltext.
Show us the query that fails, fulltext works ok here.
SELECT id,txt,ch FROM fulltxt WHERE txt LIKE %modem;
id,txt,ch
0,DSL-modem,DSL-Modem
1,Cable-Modem,Cable-Modem
SELECT id,txt,ch
Hi everyone,
I have a freeform string field in one of my tables that is xml encoded.
Basically, i can create xml tags on the fly as and when i want, and just
store the entire xml string in the field.
This eliminates the need to create a new column everytime i have a new
datatype. I can just
Hi,
Can anybody give me the optimized query for full-text searching?
User will be entering one or more words in a text box and I wanted to
display the records which has atleast one word of the user input.
Assume that my table has two fields USER and DESCRIPTION.
I wanted to search the
Rakki wrote:
Hi,
Can anybody give me the optimized query for full-text searching?
User will be entering one or more words in a text box and I wanted to
display the records which has atleast one word of the user input.
Assume that my table has two fields USER and DESCRIPTION.
I wanted
I have a TEXT field in my db (4.0) that has lists of IP numbers; can a
full-text search be done for IP numbers?
If so could you show me an example query?
Thanks
Rob
I have a TEXT field in my db (4.0) that has lists of IP numbers; can a
full-text search be done for IP numbers?
If so could you show me an example query?
Thanks
Rob
Ron McKeever [EMAIL PROTECTED] wrote on 29/04/2005 14:09:38:
I have a TEXT field in my db (4.0) that has lists of IP numbers; can a
full-text search be done for IP numbers?
Unfortunately not, because Fulltext regards the dots as terminators. The
IP address 192.168.32.2 will therefore be keyed
Since MySQL stores RowIDs with the indexed words
instead of the table's primary key IDs, and since it
uses only one index per table in any query, performing
a full-text search on a large table (several million
rows) and joining it with another large table proves
to be extremely slow
At 15:50 -0800 27-01-2005, cristopher pierson ewing wrote:
Shawn,
Okay, it turns out that I can solve my problem by reordering the
elements of the WHERE clause at the end of the query I sent before.
I've gotten good results with the following version (it breaks all
the fields in the Fulltext
On Fri, 28 Jan 2005, Santino wrote:
At 15:50 -0800 27-01-2005, cristopher pierson ewing wrote:
Shawn,
Okay, it turns out that I can solve my problem by reordering the elements
of the WHERE clause at the end of the query I sent before. I've gotten good
results with the following version (it
I'm running a query that pulls information from about six different tables
in a DB. I'd like to be able to do a fulltext search on fields in several
different tables. The end result should be that any row with a fulltext
match in any of the fields in any table gets returned. I've tried a
cristopher pierson ewing [EMAIL PROTECTED] wrote on 01/27/2005
04:01:22 PM:
I'm running a query that pulls information from about six different
tables
in a DB. I'd like to be able to do a fulltext search on fields in
several
different tables. The end result should be that any row with a
Shawn,
Thanks for the reply.
Here's the output of SHOW CREATE TABLE for one of the tables in
question:
CREATE TABLE `tblcourseextrainfo` (
`course_id` varchar(6) NOT NULL default '',
`course_description` text,
`course_intended_audience` text,
`course_keywords` text,
PRIMARY KEY
Shawn,
Okay, it turns out that I can solve my problem by reordering the elements
of the WHERE clause at the end of the query I sent before. I've gotten
good results with the following version (it breaks all the fields in the
Fulltext search into separate searches):
SELECT
t1.course_id,
Hello.
Like MyISAM data files, InnoDB data and log files are binary-compatible on
all platforms if the floating-point number format on the machines is the same.
You can move your database by copying all the relevant files. If the
floating-point formats on the machines are different but you
Is it possible to copy the database files (both MyISAM
and InnoDB) that contain tables, indices, and
full-text indices from one MySQL server to another
running/active MySQL server and start using them right
away?
I appreciate your help!
Homam
Hello.
Some information you can find in comments at:
http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html
EP [EMAIL PROTECTED] wrote:
I've looked in the documentation but didn't see any indication of the limit=
s of Full-Text Search in terms of how many characters/words it can
with Texts of up to 200 pages in one column. Full-Text
Search is handling this very well.
Thanks...
Really?! If I can follow-up with another question, does experience
suggest Full-Text Search handles a large number of such documents
efficiently? For example, I am expecting to have (up to) one
Eric,
the column type will limit the number of characters per row. A column of
type TEXT will hold up to 65,535 characters but with LONGTEXT you can put
up to 4,294,967,295 charcters into one row. I have an application with
Texts of up to 200 pages in one column. Full-Text Search is handling
have an application with
Texts of up to 200 pages in one column. Full-Text Search is handling
this
very well.
Thanks...
Really?! If I can follow-up with another question, does experience
suggest Full-Text Search handles a large number of such documents
efficiently? For example
column. Full-Text Search is handling
this
very well.
Thanks...
Really?! If I can follow-up with another question, does experience suggest
Full-Text Search handles a large number of such documents efficiently? For
example, I am expecting to have (up to) one million documents in my database
I've looked in the documentation but didn't see any indication of the limits of
Full-Text Search in terms of how many characters/words it can process per row.
For example, if I have a column with 4,000 character strings in it, can I use
it effectively in Full-Text Searching?
What
wrote:
Brent,
Thanks for the reply.
1. Is there any way to sort the boolean full-text search results in
orther of relevance as in non-bolean mode? I think it is very
important.
2. Yes, that is what I meant. You are right. I look into grep.
Thanks,
-Jalil
-Original Message-
From: Brent
1. The rows are sorted in the same order as any other query that
doesn't have and order by specified, which means usually in the order
they were entered.
2. When you mean location of matches, do you mean something like
highlighting? That's the responsibility of the interface, not the
Brent,
Thanks for the reply.
1. Is there any way to sort the boolean full-text search results in
orther of relevance as in non-bolean mode? I think it is very important.
2. Yes, that is what I meant. You are right. I look into grep.
Thanks,
-Jalil
-Original Message-
From: Brent
In the MySQL documentation, it says that: Boolean full-text searches
have these characteristics:
* They do not use the 50% threshold.
* They do not automatically sort rows in order of decreasing
relevance. You can see this from the preceding query result: The row
with the highest
) AGAINST ( '+XY-11443' IN
BOOLEAN MODE );
Wes
On Wed, 29 Sep 2004 13:22:54 -0400, Laura Scott [EMAIL PROTECTED] wrote:
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
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 supposed
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
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 query
Hello everyone,
I recently decided to perform an experiment. I was using Java to do
string comparison on sometimes large data sets (this would sometimes
take days). A friend of mine at work suggested that I use MySQL's full
text searching. I quickly made the change over and I've found that
Hi
I have a fulltext search on a dbase for lost pets.
My problem is the following:
I have dog in the database called May May which doesnt show up in the
search results. A dog called Doggy Doggy does show up however. I guess
the problem is that MySql sees May May as being a date or something
and
Pieter,
I think FTS minimum WORD size is 4 characters - you may to be searching
with 3 on 'May May'.
Not having ever used FTS; I believe you can adjust it to count 3-character
words by changing the configuration, but I'm not sure where - and it would
then need re-indexing, if I'm not
distribution.
Hope that helps.
(Oh, also what Terry said in his reply!)
Matt
- Original Message -
From: Pieter Botha
Sent: Monday, June 21, 2004 3:54 AM
Subject: Full text search problem
Hi
I have a fulltext search on a dbase for lost pets.
My problem is the following:
I have dog
Paul C. McNeil
Developer in Java, MS-SQL, MySQL, and web technologies.
GOD BLESS AMERICA!
To God Be The Glory!
-Original Message-
From: Terry Riley [mailto:[EMAIL PROTECTED]
Sent: Monday, June 21, 2004 5:08 AM
To: [EMAIL PROTECTED]
Subject: Re: Full text search problem
Lorderon [EMAIL PROTECTED] wrote:
Is it possible to define MERGE table on several tables with full-text
indexes?
Yes, but without specification of FULLTEXT index in the MERGE table.
And to make a select on the MERGE table with MATCH AGAINST?
You can permorm boolean full-text search
Hello All,
Is it possible to define MERGE table on several tables with full-text
indexes?
And to make a select on the MERGE table with MATCH AGAINST?
thanks,
-Lorderon.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi Sergei!
Thanks for replying again. I hope I'm not wasting too much of your time
with my questions! :-)
More below...
- Original Message -
From: Sergei Golubchik
Sent: Thursday, December 18, 2003 7:17 AM
Subject: Re: How boolean full-text search finds matches?
Hi!
On Dec 17
1 - 100 of 178 matches
Mail list logo
