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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
-
> 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 geolocation search. It is CJK ready. It uses Groonga as a storage
> and fulltext search engine.
>
> Doc
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
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
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
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
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
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
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') mysql
Stefan,
On Sun, Mar 8, 2009 at 1:50 PM, Stefan Onken supp...@stonki.de 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 for full details
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?
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,
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
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
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
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 its take close
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
anyother jobs like
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
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 you
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
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_PRICE_USD
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 record
--- 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)
--- 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=myisam
when I run
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 table.*
from table where match(title, description) against ('*search term*' IN
BOOLEAN MODE
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
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 in Fulltext Database]. To know
DB Team
- Original Message -
From: Niu Kun [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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.mysql.com/doc/refman/5.0
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 I execute the 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);
insert into test values(1,hello
Hi,
Try:
select * from test where match(name) against(hello in boolean mode);
Octavian
- Original Message -
From: Niu Kun [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Saturday, June 30, 2007 6:23 PM
Subject: Problem about fulltext search.
Dear all,
I'm planning to add
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:
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 your records
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
Now I
.
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)
Hello MySQL experts,
I'm trying to do
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 start
or end of the words would be ignored
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 database and I do a
SELECT * FROM my_table WHERE MATCH(Keywords
, 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 what
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: mysql@lists.mysql.com
Sent: Thursday, July 13, 2006 9:57 AM
Subject: Re: fulltext search optimization
Thanks for your respond
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
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
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
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 interprets the search
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('c++' in
boolean mode);
--
MySQL General Mailing List
For list
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 also want
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 a
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
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
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
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,
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.
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 exclude popular words like
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 words
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
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 is high and a desireable effect
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' IN BOOLEAN
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 good result in terms of query time.
select
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' IN BOOLEAN MODE)
Order
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'
)
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
http://dev.mysql.com/doc/mysql/en/fulltext-fine-tuning.html.
Michael
Dawn O'Brien wrote:
I'm trying to use the following query ::
SELECT movie_id, title, genre,
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 :
SELECT * FROM table WHERE
Given a search string of 'NASD' my default Fulltext search doesn't find
it. Wondered why? Is there a fix? Thanks for the help.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Given a search string of 'NASD' 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]
[snip]
Given a search string of 'NASD' my default Fulltext search doesn't find it.
Wondered why?
[/snip]
Quote from http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html:
MySQL uses a very simple parser to split text into words. A word is any
sequence of true word characters (letters, digits
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.
--
MySQL
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 on his would be good as well.
Thanks, Lee
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
Sincerely,
Aleksandr Guidrevitch
[EMAIL PROTECTED] wrote:
I found your query hard to understand
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 `lot`. I've created 2 helper
tables
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 `lot`. I've created 2 helper
tables : 1. `search`, which contains normalized (or stemmed) title
At 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).
The actual table I'd like
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
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
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
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 string
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 search, the search string must be at least 4 characters
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 |
('$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 do fulltext search on work. And AFAIK the search will not find
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 course
I'm running into a limitation in the fulltext search though I think by
defination a fulltext search will not - or even should not do this,
but I'd like to implement this this functionality somehow,
given in a text doc. the string: Yesterday I was superduperworkingman
at times.
I do fulltext
1 - 100 of 346 matches
Mail list logo
