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
Actually, looks like I'm wrong.
For testing purpose I made an org
"Comp&Me"
When search for "Comp" it's gonna
be shown on the list.
When search for "Comp&" it's also gonna be shown. But
"Construction Company" as well.
Then I changed the name of
the test org to "Com&Me".
Searching for "Com", th
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
Another correction: Searching for "Com", the test org is NOT
gonna be listed but all others will.
Searching for "Com&" no results at all.
�
�
>
> Actually, looks like I'm wrong.
> For testing purpose I made an org
> "Comp&Me"
> When search for "Comp" it's gonna
> be shown on the list.
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 be listed but all others will.
Searching for "Com&" no results at all.
�
�
Actually, looks like I'm wrong.
For testing purpose I mad
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
> 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
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
On Sep 8, 2008, at 10:58 AM, Fco. Mario Barcala Rodríguez wrote:
Hi all:
I was reading documentation and searching into
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 and
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
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://lists.mysql
a) You setup a special index (full text).
b) Full text indexes can only be created on MyISAM table types.
c) MyISAM does support transactions, it works by table locking. If
you are not specifically using transactions, you don't need to worry
about it. "not transaction safe" just means that t
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 on
Good Evening David-
Have you considered using Lucene ?
http://lucene.apache.org/java/docs/
M--
This email message and any files transmitted with it contain confidential
information intended only for the person(s) to whom this email message is
addressed. If you have received this email message i
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
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
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
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
"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
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
On Wed, 15 Dec 2004, EP wrote:
> Thomas Spahni <[EMAIL PROTECTED]> wrote:
>
> > 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
> > appli
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
Thomas Spahni <[EMAIL PROTECTED]> wrote:
> 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
"EP" <[EMAIL PROTECTED]> wrote on 15/12/2004 15:44:15:
> Thomas Spahni <[EMAIL PROTECTED]> wrote:
>
> > 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 charcter
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
---
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 26, 2004 6:30 AM
To: Jalil Feghhi
Cc: [EMAIL PROTECTED]
Subject: Re: Full-Text Search
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
Baisley [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 26, 2004 6:30 AM
To: Jalil Feghhi
Cc: [EMAIL PROTECTED]
Subject: Re: Full-Text Search
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 o
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
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,
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
Hi Pieter,
That's because "may" is a stopword in MySQL's full-text indexing, by
default (like "can," "the," etc). You can define your own stopword file
with the ft_stopword_file variable. And you can find the default, built-in
list of stopwords in the file myisam/ft_static.c of the source
distri
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.
"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 sear
At the moment MySql indexes only plain text.
You have to convert your document to text and then insert the text
into the column.
Santino
At 9:50 +0200 23-10-2003, Jan-Erik Öhman wrote:
Hi,
has anybody done full-text indexing of pdf and word documents stored in TEXT
columns?
I could find no refere
Sorry...
I read mysql page and I read that is need mysql 4 and my server only has
mysql 3.23.51!!!
I'll try to contact my ISP in order to they update the server.
Thanks all,
Nuno Lopes
> SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvor*' in boolean mode );
>
> Santino
>
> >Hello,
> >
> >I
In mysql 4.0.12:
SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvor*' in boolean mode );
Santino
Hello,
I have a table with just one column and with 1000 rows. It's indexed using
full text.
I've tried MATCH with AGAINST and LIKE and nothing works right!
I've tried:
SELECT * FROM 'test' WHERE M
> On Sunday, June 15, 2003, at 01:36 PM, Nuno Lopes wrote:
>
> > I have a table with just one column and with 1000 rows. It's indexed
> > using
> > full text.
> > I've tried MATCH with AGAINST and LIKE and nothing works right!
> >
> > I've tried:
> > SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('
On Sunday, June 15, 2003, at 01:36 PM, Nuno Lopes wrote:
I have a table with just one column and with 1000 rows. It's indexed
using
full text.
I've tried MATCH with AGAINST and LIKE and nothing works right!
I've tried:
SELECT * FROM 'test' WHERE MATCH (p) AGAINST ('arvor*');
but if I do
SELECT
Hi!
On Mar 09, Shawn wrote:
> In http://www.databasejournal.com/features/mysql/ they give an example
> of a BOOLEAN MODE search using "here" which they also pointed out was a
> stop word in regular full text searches.
>
> mysql> SELECT copy, MATCH(copy)
> AGAINST ('+here past' IN BOOLEAN MODE)
Hi
Try this.
select * from table where upper(text) like upper('%dog%')
Then all words with 'dog' in it, will appears in your query.
Hope this helps
/Frank
>
> I'm working on a full text search that will search through subject
> lines. The search word is not necessarily a discreet word bu
Hi,
As of Version 4.0.1 you can use the truncation operator * in boolean mode:
select firstname from contacts where match(firstname,lastname) against
('steff*' in boolean mode);
This will match steff , steffa, steffan, steffane, steffans
But of course not "stef" unless you use 'stef*' .
R
full text search is different than pattern match. If
you want to return stef, you have to use pattern
match.
Qunfeng
--- "Steffan A. Cline" <[EMAIL PROTECTED]> wrote:
> Am I missing something on mysql full text search?
>
>
> I was using a simple statement like
> select firstname from contacts
At 13:29 +0100 11/2/02, ddd wrote:
i know !
That wasn't apparent from your message.
but how to solve it ??!
can anybody help how to search word with "-"
Use a phrase search in boolean mode, which requires the original
phrase exactly as present in the table.
thanx
Paul DuBois wrote:
At
i know !
but how to solve it ??!
can anybody help how to search word with "-"
thanx
Paul DuBois wrote:
At 21:45 +0100 11/1/02, ddd wrote:
hello
i'm using mysql 3.23.41
i want to search in fulltext indexed table for word "Down-Syndrom"
but the
result is the same like when I search "138721-
At 21:45 +0100 11/1/02, ddd wrote:
hello
i'm using mysql 3.23.41
i want to search in fulltext indexed table for word "Down-Syndrom" but the
result is the same like when I search "138721-Syndrom"..
WHY
"-" isn't considered part of a word so you're really searching for
"down" or "syndrom" i
On Sun, Oct 13, 2002 at 10:58:53PM +, Sergei Golubchik wrote:
> Hi!
>
> On Oct 13, Alan wrote:
> >
> > mysql> select title from content where match
> > (title,center_content,right_content) against ('updates');
> > +-+
> > | title |
> > +-
Hi!
On Oct 13, Alan wrote:
>
> mysql> select title from content where match
> (title,center_content,right_content) against ('updates');
> +-+
> | title |
> +-+
> | eXI Systems' Latest Updates |
> +-
On Sun, Oct 13, 2002 at 02:48:38PM -0500, Paul DuBois wrote:
[snip]
> >As far as I can tell, this *should* be working. Can anyone help please?
>
> Try dropping the FULLTEXT index and then add it again. (Alternatively,
> dump and reload the table).
I did drop the table this morning, just in cas
At 11:11 -0700 10/13/02, Alan wrote:
>Hi folks, new to the list, hoping I'm posting to the right one.
>
>I've been using the full-text search for a clients site and it works
>great... the only problem is I want to change the minimum word length
>from 4 to lower, such as 2 or 3. Reading the docs t
On Sun, 25 Aug 2002, andy wrote:
> Hi there,
>
> I am trying to write a php script to perform a full text search on a mysql
> db. I do a match against... and it digs out some results out of the db.
>
> There are 2 problems:
>
> 1.
> 2. Is it possible with php to underline the keyword inside t
Pada Sun, 25 Aug 2002 16:33:51 +0200
"andy" <[EMAIL PROTECTED]> menulis :
> Hi there,
>
> I am trying to write a php script to perform a full text search on a mysql
> db. I do a match against... and it digs out some results out of the db.
>
> There are 2 problems:
>
> 1. How can I restrict the
David,
Tuesday, June 04, 2002, 5:43:16 PM, you wrote:
DS> I've implemented a full-text index on several of my database fields in a
DS> table, populated those fields with some very simple, yet distinct records,
DS> and have run recommended queries against that table. Alas, I still end up
DS> getti
Hi!
On Jan 19, Gordan Bobic wrote:
> Hi!
>
> The part that I thought could be a "bug" was the one you didn't quote.
I still remeber that part, there's no need to explain it again :-)
> > It's not a "known" bug as the code is rather new.
> > Can you create a test case for this ?
>
> Possibly,
Hi!
> > 1.1) Full Text Search can, according to the manual, be performed without
> > the FTS index, but it is slower.
> > 1.2) MySQL can only use 1 index per join per table.
> >
> > => This means that if I specify the USE INDEX (some_non_fulltext_index),
> > the FTS will be performed without the
Hi!
On Jan 18, Gordan Bobic wrote:
> Hi.
>
> I thought it would be useful to share my findings. They all relate to the
> 4.0.1 release. It would be nice to have some clarification on whether this is
> expected behaviour, whether this behaviour is wrong (i.e. bug, corrupted
> index, etc), and
Hi!
Unfortunately, I get too many e-mails to handle help requests
which are sent directly to me.
If you have purchased MySQL support, you may write to
[EMAIL PROTECTED], and will get an answer quickly. If you
would like to purchase support, please see the Support
section of our web site:
h
Hi Anton,
- Original Message -
From: "Tichawa Anton" <[EMAIL PROTECTED]>
> I have problems with full-text search. My table contains text lines from
> computer-generated log files rather than documents written by humans,
> and so my first problem is that I need an exact match rather than
Hi!
On Sep 10, [EMAIL PROTECTED] wrote:
> Where can I find a description of the algorithm that mysql uses for
> weighting results from a full text search?
in the source myisam/ftdefs.h
> Is there a way to provide some user specified criteria to alter the
> weighting? (i.e. a callback mechanis
x, though...
From: "Nessi" <[EMAIL PROTECTED]>
To: "Sebastiaan J.A. Kamp" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, June 26, 2001 2:31 PM
Subject: Re: Full text search gotchas
> Hello,
>
> thanks for your reply. I was wondering...I thou
Hello,
thanks for your reply. I was wondering...I thought the LIKE function
is only for single words? I have to admit I never tested it and started
right off with fulltext option.
So would following work then...
Lets assume one entry in somefield is: "The children are playing on the
play-ground"
At 13:53 +0200 2001-06-26, Bruce Stewart wrote:
If you searched for '% john %' - note the spaces, you would not find
'johnson' etc..
*Sigh* Since when do wildcards work with the fulltext index?
Besides, there are characters beside a space wich can delimit words.
Three examples: Commas. Line br
Partial searches can be done with 'LIKE', i.e.:
SELECT * FROM yourtable WHERE somefield LIKE '%searchstring%'
The '%' is MySQLs wildcard here, so if you only want strings starting with
your searchstring, use 'searchstring%'
Regards,
Sebastiaan J.A. Kamp
> Hello Matthew
>
> I would be quite i
If you searched for '% john %' - note the spaces, you would not find
'johnson' etc..
-Original Message-
From: Matthew Brealey [mailto:[EMAIL PROTECTED]]
Sent: Tue, 26 June 2001 11:29
To: [EMAIL PROTECTED]
Subject: Full text search gotchas
We're having quite a lot of difficulty with MySQ
Hello Matthew
I would be quite interested to know how you managed to make a
partial search. I built a search engine recently using fulltext, and
partial searches would never work. Say I type in child, I would never
get any results with children.
This is quite weird since you seem to want it the w
On Wed, 20 Jun 2001 15:22:22 -0700
"Ryan Knopp" <[EMAIL PROTECTED]> wrote:
> I'm trying to use the Full text Search with the japanese language using
> either doublebyte or singlebyte character. The problem is it doesn't
> seem
> to be working at all for any searches. I use a sql statement like t
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
79 matches
Mail list logo