[ANN] Mroonga 9.01 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 9.01 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 9.00 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 9.00 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

Re: [ANN] Mroonga 8.09 - Fast fulltext search for all languages on MySQL

Hi, Sorry, There was wrong release information in Mroonga 8.09. The MySQL 8 is not supported. That is still being handled. On 2018/11/29 14:12, Horimoto Yasuhiro wrote: > Hi, > > Mroonga 8.09 has been released! > > Mroonga is a MySQL storage engine that supports fast fullte

[ANN] Mroonga 8.09 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 8.09 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 8.07 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 8.07 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 8.06 - Fast fulltext search for all languages on MySQL

Mroonga 8.06 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org/docs

[ANN] Mroonga 8.03 - Fast fulltext search for all languages on,MySQL

Mroonga 8.03 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org/docs

[ANN] Mroonga 8.02 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 8.02 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 8.01 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 8.01 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 8.00 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 8.00 has been released! This is a major version up! But It keeps backward compatibility. You can upgrade to 8.0.0 without rebuilding database. Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage

[ANN] Mroonga 7.11 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 7.11 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 7.10 - Fast fulltext search for all languages on,MySQL

Hi, Mroonga 7.10 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. * Document: http://mroonga.org/docs/ * How to install: http://mroonga.org/docs

[ANN] Mroonga 7.09 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 7.09 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 7.07 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 7.08 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 7.07 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 7.07 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 7.06 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 7.06 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 7.05 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 7.05 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 7.04 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 7.04 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 7.03 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 7.03 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 7.02 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 7.02 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 7.01 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 7.01 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 7.00 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 7.00 has been released! Even though major version upgrade, it keeps compatibility of Mroonga database. Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document

[ANN] Mroonga 6.11 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 6.11 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

Re: [ANN] Mroonga 6.10 - Fast fulltext search for all languages on MySQL

:03, Kentaro Hayashi wrote: > > Hi, > > Mroonga 6.10 has been released! > > Mroonga is a MySQL storage engine that supports fast fulltext search > and geolocation search. It is CJK ready. It uses Groonga as a storage > and fulltext search engine. > > Document: > ht

Re: [ANN] Mroonga 6.10 - Fast fulltext search for all languages on MySQL

Can you post some benchmarks or comparison with elasticsearch? Sent from ProtonMail mobile Original Message On 29 ott 2016 05:03, Kentaro Hayashi wrote: Hi, Mroonga 6.10 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and

[ANN] Mroonga 6.10 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 6.10 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 6.09 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 6.09 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 6.08 - storage engine, fast fulltext search, CJK ready

Hi, Mroonga 6.08 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 6.07 - Fast fulltext search for all languages on MySQL

Hi, Mroonga 6.07 has been released! Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ How to install: Install Guide http://mroonga.org

[ANN] Mroonga 6.06 - storage engine, fast fulltext search, CJK ready

Hi, Mroonga 6.06 has been released! ## What is Mroonga? Mroonga is a MySQL storage engine that supports fast fulltext search and geolocation search. It is CJK ready. It uses Groonga as a storage and fulltext search engine. Document: http://mroonga.org/docs/ The characteristics of Mroonga

Re: help with fulltext search

Stefan, On Sun, Mar 8, 2009 at 1:50 PM, Stefan Onken wrote: > Hello, > > I am bit puzzled about combining mysql fulltext search into our > current search: > > I am not able to combine a fulltext search with other selections, > please see http://pastebin.com/m23622c39

help with fulltext search

Hello, I am bit puzzled about combining mysql fulltext search into our current search: I am not able to combine a fulltext search with other selections, please see http://pastebin.com/m23622c39 for full details. The moment I am using "...where a=2 OR match (bla) AGAINST ('foo'

Re: accent sensitivity in fulltext search

Thanks Santino, but unfortunately didn't help . I tried utf8_bin, just for checking, same results¸ Not even the case sensitivity is respected. The following queries return the same results: select name from people where match(name) against ('"königsberger"' in boolean mode); select name from pe

Re: accent sensitivity in fulltext search

Hi, try to set the collation to utf8_unicode_ci. I have had the inverse problem and I solved with utf8_general_ci. Santino At 19:33 +0100 16-02-2009, Salam Baker Shanawa wrote: Hi, How can I have accent sensitive, case insensitive fulltext query? version: 5.0.45 The database, tables, connecti

accent sensitivity in fulltext search

Hi, How can I have accent sensitive, case insensitive fulltext query? version: 5.0.45 The database, tables, connection, data etc. are all utf8. select name from people where match(name) against ('"königsberger"' in boolean mode); shouldn't return konigsberger. Any idea, collation? Rega

Re: improve performance on FULLTEXT search.

formatn command and if conditions, but still it take 3 min >> > > Are you sure when you are running the fulltext search, the table isn't > locked because you are building the index or altering the table? > > Mike > > > > select >> >> >>

Re: improve performance on FULLTEXT search.

At 11:38 AM 6/12/2008, you wrote: Hi Sebastian, I tried to order the column as close as possible to the table structure and removed all the formatn command and if conditions, but still it take 3 min Are you sure when you are running the fulltext search, the table isn't locked because yo

Re: improve performance on FULLTEXT search.

Hi Sebastian, I tried to order the column as close as possible to the table structure and removed all the formatn command and if conditions, but still it take 3 min select ITEM_ID,ITEM_TITL,AUCT_START_DATE,AUCT_END_DATE,AUCT_DURTN_DAYS,AUCT_TYPE_CODE,LEAF_CATEG_ID,SLR_ID,START_PRICE_USD,RSRV_PR

Re: improve performance on FULLTEXT search.

On 6/12/08, Ananda Kumar <[EMAIL PROTECTED]> wrote: > > > > On 6/12/08, Sebastian Mendel <[EMAIL PROTECTED]> wrote: >> >> Ananda Kumar schrieb: >> >>> Hi All, >>> We have table with 99 Million records, with fulltext index. >>> But when there is not load the sql's performance in just 6 sec, but when

Re: improve performance on FULLTEXT search.

On 6/12/08, Sebastian Mendel <[EMAIL PROTECTED]> wrote: > > Ananda Kumar schrieb: > >> Hi All, >> We have table with 99 Million records, with fulltext index. >> But when there is not load the sql's performance in just 6 sec, but when >> anyother jobs like Index creation or data load is happening it

Re: improve performance on FULLTEXT search.

Ananda Kumar schrieb: Hi All, We have table with 99 Million records, with fulltext index. But when there is not load the sql's performance in just 6 sec, but when anyother jobs like Index creation or data load is happening its take close to 3 min for the same query to execute, any ways to improve

improve performance on FULLTEXT search.

Hi All, We have table with 99 Million records, with fulltext index. But when there is not load the sql's performance in just 6 sec, but when anyother jobs like Index creation or data load is happening its take close to 3 min for the same query to execute, any ways to improve the performance of this

Re: different results between FULLTEXT search and LIKE search

--- Lamp Lists <[EMAIL PROTECTED]> wrote: > > --- Lamp Lists <[EMAIL PROTECTED]> wrote: > > > hi, > > I created table "tasks" > > create table tasks( > > task_id, int(4) not null primary key, > > task text not null, > > resolution text not null, > > fulltext (task, resolution) > > )engine=my

Re: different results between FULLTEXT search and LIKE search

--- Lamp Lists <[EMAIL PROTECTED]> wrote: > hi, > I created table "tasks" > create table tasks( > task_id, int(4) not null primary key, > task text not null, > resolution text not null, > fulltext (task, resolution) > )engine=myisam > > when I run > > seect * from tasks match(task,resolution

different results between FULLTEXT search and LIKE search

hi, I created table "tasks" create table tasks( task_id, int(4) not null primary key, task text not null, resolution text not null, fulltext (task, resolution) )engine=myisam when I run seect * from tasks match(task,resolution) against('"certain service"' in boolean mode) I would get one reco

RE: fulltext search option

; Sent: Thursday, July 26, 2007 7:56 PM > To: mysql@lists.mysql.com > Subject: fulltext search option > > I'm having a problem with the fulltext searching, and was > looking for some > help. > > i'm currently working with the following query: > > select t

fulltext search option

I'm having a problem with the fulltext searching, and was looking for some help. i'm currently working with the following query: select table.* from table where match(title, description) against ('*search term*' IN BOOLEAN MODE) the reason I am using boolean mode, is so that it matches things l

Re: Problem about fulltext search.

Thank you for your information. It's really helpful.:) It seems that I'll have to dig deep into the fulltext search functionality. 2007/7/2, ViSolve DB Team <[EMAIL PROTECTED]>: Hi, There are some words which are drawn as "Stop words" [Words which are not searchable

Re: Problem about fulltext search.

return rows. Thanks ViSolve DB Team - Original Message - From: "Niu Kun" <[EMAIL PROTECTED]> To: Sent: Sunday, July 01, 2007 7:53 AM Subject: Re: Problem about fulltext search. Steve Edberg wrote: At 11:23 PM +0800 6/30/07, Niu Kun wrote: To quote from http://dev.

Re: Problem about fulltext search.

Steve Edberg wrote: > At 11:23 PM +0800 6/30/07, Niu Kun wrote: > > To quote from > > http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html > > > "... words that are present in more than 50% of the rows are considered > common and do not match." > > 'hello' appears in both (100%) of

Re: Problem about fulltext search.

Octavian Rasnita wrote: > Hi, > > Try: > > select * from test where match(name) against("hello" in boolean mode); > > Octavian Thank you for your suggestion. I tried, but failed.:( -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.my

Re: Problem about fulltext search.

Hi, Try: select * from test where match(name) against("hello" in boolean mode); Octavian - Original Message - From: "Niu Kun" <[EMAIL PROTECTED]> To: Sent: Saturday, June 30, 2007 6:23 PM Subject: Problem about fulltext search. Dear all, I'm pla

Re: Problem about fulltext search.

At 11:23 PM +0800 6/30/07, Niu Kun wrote: Dear all, I'm planning to add fulltext search to my database. I've got the following test command: create table test(id int, name varchar(20)); alter table test add fulltext(name); insert into test values(1,"hello world"); inser

Problem about fulltext search.

Dear all, I'm planning to add fulltext search to my database. I've got the following test command: create table test(id int, name varchar(20)); alter table test add fulltext(name); insert into test values(1,"hello world"); insert into test values(1,"hello"); When

RE: Fulltext search dilemma (IN BOOLEAN MODE) [RESOLVED]

pened, the server was always shut down properly. -Andy -Original Message- From: Jerry Schwartz [mailto:[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 4:10 PM To: Andreas Iwanowski Cc: mysql@lists.mysql.com Subject: RE: Fulltext search dilemma (IN BOOLEAN MODE) Sorry, I have no idea wh

RE: Fulltext search dilemma (IN BOOLEAN MODE)

1, 2007 2:22 PM > To: Jerry Schwartz > Cc: mysql@lists.mysql.com > Subject: RE: Fulltext search dilemma (IN BOOLEAN MODE) > > Hi, thank you for your reply. > > I have used the option ft_min_word_len=3. > If I have something like > 1. "Key West" > in the dat

RE: Fulltext search dilemma (IN BOOLEAN MODE)

[EMAIL PROTECTED] Sent: Thursday, February 01, 2007 1:52 PM To: Andreas Iwanowski; mysql@lists.mysql.com Subject: RE: Fulltext search dilemma (IN BOOLEAN MODE) Unless you changed the minimum word length, "Key" would be ignored because it is too short. I would think the quotation marks at the

RE: Fulltext search dilemma (IN BOOLEAN MODE)

ington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Andreas Iwanowski [mailto:[EMAIL PROTECTED] > Sent: Thursday, February 01, 2007 12:49 PM > To: mysql@lists.mysql.com > Subject: Fulltext search dilemma (IN BOOLEAN MODE) > &g

Fulltext search dilemma (IN BOOLEAN MODE)

Hello MySQL experts, I'm trying to do a full text search on an indexed Keywords column that contains quotation marks, and it's giving me a headache. Suppose there are records in the database containing the folling keywords: 1. "Miami Beach" City 2. "Key West" Florida 3. "Key West" Beach Florida

Re: fulltext search optimization

ong. You might as well be searching on LIKE "%.mp3%", probably would be about just as fast, and you could use a memory table if you wanted. - Original Message - From: "Svilen Spasov (Ancient Media)" <[EMAIL PROTECTED]> To: Sent: Thursday, July 13, 2006 9:57 AM Su

Re: fulltext search optimization

Thanks for your respond. Here is the CREATE TABLE: CREATE TABLE `results_1` ( `id` int(11) NOT NULL auto_increment, `filename` varchar(255) collate cp1251_bulgarian_ci default NULL, `fileext` varchar(10) collate cp1251_bulgarian_ci default NULL, `username` varchar(16) collate cp1251_bulg

Re: fulltext search optimization

Svilen Spasov (Ancient Media) wrote: Hello, I have a website with a MySQL database and I have a table with ~2 millions row (usernames, filenames; ~120MB db data file and ~230MB db index file) with I would like to search using the fulltext indeces. Unfortunately the server get loaded pretty m

fulltext search optimization

Hello, I have a website with a MySQL database and I have a table with ~2 millions row (usernames, filenames; ~120MB db data file and ~230MB db index file) with I would like to search using the fulltext indeces. Unfortunately the server get loaded pretty much. It always stays on 20 load av

Re: Fulltext search for term 'c++'

lect f1 from t1 where match(f1) against ('"c++"' in boolean mode); HTH, James At 12:30 pm -0700 10/5/06, klute wrote: >Is there any way I can search for a term such as 'c++' >using a fulltext search index? >select f1 from t1 where match(f1) against('

Fulltext search for term 'c++'

Hello all, Is there any way I can search for a term such as 'c++' using a fulltext search index? Here is the query that should return rows but it does not. I suspect that the trailing "++" are treated as wildcards and are not fulltext indexed by mysql. It seems like mysql i

Best practice: FULLTEXT search & InnoDB transactions & replication

Hi, We have moved from Mysql4 to MySQL5 and are currently planning our new database schema. In this new approach we would like to move to InnoDB's storage engine for transaction support and still want to use MySQL's FULLTEXT search capabillities. And to make things easy we al

Re: fulltext search

On Sun, 18 Dec 2005, Octavian Rasnita wrote: > Hi, > > Please tell me how can I configure MySQL 5 in order to be able to search > (using fulltext indexes) for combined words like "s-au". > > This is a single word and not 2 words but I think MySQL thinks that there > are 2 words, one of them having

Re: fulltext search

> AFAIK you are right - MySQL treats a hypen as a word-break. And, AFAIK you cannot modify that behaviour. > > The only possibility, I think, would be to modify the source and compile your own MySQL. :-( > > However if you do a full-text search using IN BOOLEAN MODE, then you can put quotes arou

Re: fulltext search

AFAIK you are right - MySQL treats a hypen as a word-break. And, AFAIK you cannot modify that behaviour. The only possibility, I think, would be to modify the source and compile your own MySQL. :-( However if you do a full-text search using IN BOOLEAN MODE, then you can put quotes around hype

fulltext search

Hi, Please tell me how can I configure MySQL 5 in order to be able to search (using fulltext indexes) for combined words like "s-au". This is a single word and not 2 words but I think MySQL thinks that there are 2 words, one of them having a single character, and the second 2 chars, so it is not

Re: Need help with fulltext search and left join

For me, it looks as if you confused the order of join and where. It should be: select ... from ... join ... where ... order by ... Stefan Am Sunday 23 October 2005 13:21 schrieb Grant Giddens: > Hi, > > I keep getting errors on this query and I'm not sure > why. I'm using mysql version 4.0.22.

Need help with fulltext search and left join

Hi, I keep getting errors on this query and I'm not sure why. I'm using mysql version 4.0.22. Any ideas? SELECT pn_coupons_store.store_name, pn_coupons_store.store_name_short, pn_coupons_coupons.store_id, pn_coupons_coupons.coupon_id, pn_coupons_dealtype.dealtype_name, pn_coupons_coupons.co

Re: fulltext search on words inside words

Merlin wrote: I am wondering if it is possible to find words inside words with the help of fulltext search. Is this possible? Google does that, so somehow there should be a way. Somehow I don't think that Google runs on a single MySQL database. Full text indexes in MySQL mean that &

fulltext search on words inside words

Hi there, I am wondering if it is possible to find words inside words with the help of fulltext search. For example: Search for: "Antenne" Schould also find "Stabantenne" Is this possible? Google does that, so somehow there should be a way. Another thing is, how do I e

Re: FULLTEXT search result requirement

2005/8/11, Eric Jensen <[EMAIL PROTECTED]>: > I am looking into using the FULLTEXT search features for our FAQ > system. Problem is the 50% limitation. We aren't going to have > thousands of questions or articles, so the odds of most of the > questions/articles matching i

FULLTEXT search result requirement

I am looking into using the FULLTEXT search features for our FAQ system. Problem is the 50% limitation. We aren't going to have thousands of questions or articles, so the odds of most of the questions/articles matching is high and a desireable effect for us. Is there a away to disable

Re: Problem in Fulltext Search

t;[EMAIL PROTECTED]> wrote: >Hi, > >We have a table containing more than 15 million rows of data, can anybody >please help in >this problem of fulltext search described below. > >The following query is giving a good result in terms of query time. > >select field1

Re: Problem in Fulltext Search

"Suryya Ghosh" <[EMAIL PROTECTED]> wrote on 08/05/2005 09:50:27 AM: > Hi, > > We have a table containing more than 15 million rows of data, can > anybody please help in this problem of fulltext search described below. > > The following query is giving a

Problem in Fulltext Search

Hi, We have a table containing more than 15 million rows of data, can anybody please help in this problem of fulltext search described below. The following query is giving a good result in terms of query time. select field1, field2 from tblMerge where MATCH(field1) AGAINST('food'

Re: problem with fulltext search

"another" is a stop word. The default list of stopwords is in myisam/ft_static.c in a source distribution. See the manual for more . Michael Dawn O'Brien wrote: I'm trying to use the following query :: SELECT movie_id, title, genre,

problem with fulltext search

I'm trying to use the following query :: SELECT movie_id, title, genre, description, TRIM( TRAILING ',' FROM actors ) , director, disclaimer, rating, year, ( MATCH ( title, description ) AGAINST ( 'another' ) ) AS score FROM movie_details WHERE ( MATCH ( title, description ) AGAINST ( 'another' ) )

accent, quote and fulltext search

Hello, It seems it is possible to get ride of accent problems in fulltext search (but I don't know how to). I am using 4.1.8a version of mysql and I am not enable to find any accentuated word from its non-accent version (says 'siecle' for 'siècle'). For example :

RE: Fulltext search question

[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 sequenc

Fulltext search question

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]

FullText search question

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]

Re: Fulltext search string less than 4 characters

AIL PROTECTED]> wrote: > I want to know on Solaris how I could lower the the minimum fulltext > search string from 4 to 3. Right now using the FullText search any > string less than 4 chars is ignored. I'm sure there's a link explaining > how. Maybe UNIX help in general

Fulltext search string less than 4 characters

I want to know on Solaris how I could lower the the minimum fulltext search string from 4 to 3. Right now using the FullText search any string less than 4 chars is ignored. I'm sure there's a link explaining how. Maybe UNIX help in general on his would be good as well. Thanks, Lee G.

Re: Optimize query and/or db structure, FullText search + sort by other fields

KE '%block%'; For me there is 1536 (?!) 5. "SET GLOBAL key_cache_block_size = 2048"; 6. go "REPAIR TABLE end_time" (the table with fulltext search you are querying) 7. here we are, all the MATCH() with ORDER BY queries take 0.01, only some of them are 0.02 secs, not more

Re: Optimize query and/or db structure, FullText search + sort by other fields

15:25 +0200 5-11-2004, Aleksandr Guidrevitch wrote: Hi All, this was already posted on mysql forum "preformance", but forums are really slow, so sorry for the crosspost :) My objective is to implement quick, really quick complex fulltext search with 'order by' (< 2 seconds

Re: Optimize query and/or db structure, FullText search + sort by other fields

poration - Spruce Pine Aleksandr Guidrevitch <[EMAIL PROTECTED]> wrote on 11/05/2004 08:25:00 AM: > Hi All, this was already posted on mysql forum "preformance", > but forums are really slow, so sorry for the crosspost :) > > > My objective is to implement quick, re

Optimize query and/or db structure, FullText search + sort by other fields

Hi All, this was already posted on mysql forum "preformance", but forums are really slow, so sorry for the crosspost :) My objective is to implement quick, really quick complex fulltext search with 'order by' (< 2 seconds). The actual table I'd like to search is

Re: Fulltext search Strategy - Need Help

Search '+ford +focus' [in boolean mode] Santino At 13:22 + 3-11-2004, Lee Denny wrote: Hello, I'm doing fairly straight forward fulltext searches, but I want to nest them - basically do a keyword search on 'phrase 1' and then search the results this returns for 'phrase 2', for example if phrase

Fulltext search Strategy - Need Help

Hello, I'm doing fairly straight forward fulltext searches, but I want to nest them - basically do a keyword search on 'phrase 1' and then search the results this returns for 'phrase 2', for example if phrase 1 is 'ford' and phrase 2 is 'focus' - I search once for 'ford' and then go through the re

Re: match a fulltext search with a "-" dash, can't match if - exist

Louie, Mysql treats the dash as a word separator. There's no way to change that unless you change the source code and recompile Mysql. Also, the default min word length is 4. So not only is "E" not matched; even "018" will not be matched. The min word length is easily configurable, though. Put a

Re: match a fulltext search with a "-" dash, can't match if - exist

On Mon, Oct 18, 2004 at 11:19:55AM +0800, Louie Miranda wrote: > > mysql> select * from fullsearch where match (title,body) against ('018-E'); > Empty set (0.00 sec) > > > it returns an empty set, is it possible to also search with "-" dash? chars? If I remember correctly, you need to pass the

Re: match a fulltext search with a "-" dash, can't match if - exist

> mysql> select * from fullsearch where match (title,body) against ('018-E'); > Empty set (0.00 sec) > > > it returns an empty set, is it possible to also search with "-" dash? chars? I'm not an expert but others will correct me : In a fulltext s

match a fulltext search with a "-" dash, can't match if - exist

this is a working example i found on mysql.com this is my example of fullsearch mysql> desc fullsearch; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+-

RE: Fulltext Search help

On Fri, 15 Oct 2004 20:05:57 -0400, "leegold" <[EMAIL PROTECTED]> said: > > On Fri, 15 Oct 2004 15:00:10 -0700, "Chris W. Parker" ... But maybe there's a better way? I > wish I could do *searchstring* in Fulltext even if the speed was slow as > molasass it's the spec the user wants. Of cours

RE: Fulltext Search help

d_txt`) AGAINST ('$radio_keyword' IN BOOLEAN MODE)"; At 20:05 -0400 15-10-2004, leegold wrote: On Fri, 15 Oct 2004 15:00:10 -0700, "Chris W. Parker" <[EMAIL PROTECTED]> said: leegold <mailto:[EMAIL PROTECTED]> on Friday, October 15, 2004 2:32 PM said: > I

RE: Fulltext Search help

On Fri, 15 Oct 2004 15:00:10 -0700, "Chris W. Parker" <[EMAIL PROTECTED]> said: > leegold <mailto:[EMAIL PROTECTED]> > on Friday, October 15, 2004 2:32 PM said: > > > I do fulltext search on "work". And AFAIK the search will not find > >

  1   2   3   4   >