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 c
en [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 as a part of the keyword
>>
>> Hello,
>>
>> (my response is not top-posted)
>> On 7/2/2013 12:50 PM, l
anged the name of
the test org to "Com&Me".
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 query
>
> SELECT name,
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 searc
Searching for "Com", the test org is gonna be listed.
>
> Though, "Com&" no results at
> all.
> ?!?
> �
>>
>
>>
>
>>
>
>> Hi to all,
>
>>
>
>>
>
>>
>
>> I have
the test org to "Com&Me".
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 query
SELECT name, org_id,
address_id
FROM organization
WHERE org_ac
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('AB&C*' IN BOOLEAN
MODE)
and I'm not getting any results. And there IS a org AB&C,
Inc.
My assumption i
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
Sorry, I don't understand your answer. Could you kindly explain in more details?
Thanks,
Jack
--- On Fri, 4/24/09, zhu dingze wrote:
From: zhu dingze
Subject: Re: Full Text Search Problem
To: mysupp...@asuma.com
Cc: mysql@lists.mysql.com
Date: Friday, April 24, 20
'Words' shows in more than 50% rows will be regards as a stop words.
2009/4/24
> 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), DEPA
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 article
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 article
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 article
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 def
> 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
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 k
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 meth
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 mo
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
To
'%..whatever..&'
UNION
SELECT "I'M A NEWS",ID_NEWS as ID_TO_RETURN
FROM News T1
WHERE TITLE like '%..whatever..&' OR CONTENT like '%..whatever..&'
Aloha!
Claudio Nanni
-Messaggio originale-
Da: nikos [mailto:[EMAIL PRO
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 author
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?
>
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 ar
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
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
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
OR
n the result but at the
same 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
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 on it
From: 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
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 sav
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
> >> hand
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.
Le
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
[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 the
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 million.
t; need to have it encrypted. 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 i
s, 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 i
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 a
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 a specific storage
engine for
a table)?
b)What storage engine(s) are required?
c)Are there
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'
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:
Sent: Friday, July 06, 2007 9:19 PM
Subject: Full Text Search,
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
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 transa
mmand will help a lot, and is an alternate method of
achieving backups.
Dan
On 8/18/06, AmirBehzad Eslami <[EMAIL PROTECTED]> wrote:
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 encode
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
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 need
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 mysq
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.
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
character programming language.
Hope that gives you some ideas.
- Original Message -
From: "Harini Raghavan" <[EMAIL PROTECTED]>
To:
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 capabil
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
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
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
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
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)&
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
FR
rpose...), 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 -
matc
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
th
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 fi
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
>
> SELE
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 sp
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 sp
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
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
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 to
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 DES
"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.
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
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!
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 breaks
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 sea
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,
t1.
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 (`cou
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 wi
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
syn
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
__
rcters into one row. I 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 s
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
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 t
GTEXT 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
> > this
> > very well.
>
>
> Thanks...
>
> Really?! If I can follow-up with a
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 this
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?
W
M, Jalil Feghhi 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--
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
datab
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 re
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
> 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,
> >
> > I ha
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 to find the
> record. The original developer was using full t
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 h
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 i
crit_results);
God Bless
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
he file myisam/ft_static.c of the source
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
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 mistaken.
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
"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?
>
Yo
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:http://lists.mysql.com/[EM
1 - 100 of 187 matches
Mail list logo
