: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/en/fulltext-search.html
... words that are present in more than 50% of the rows are considered
common and do not match
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
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
Hi,
I'm using MySQl 3.23.52 on RedHat Linux 6.2
I have a table that is indexed on the description column as FULLTEXT. I
allow the user to enter text in an input field and I return matching rows.
I've noticed that writing a query such as:
SELECT EDescript FROM HSCodes WHERE MATCH(EDescript)
when will we be able to set our own word determination?
when will mysql support multibyte fulltext index
_
ÏíÓÃÊÀ½çÉÏ×î´óµÄµç×ÓÓʼþϵͳ¡ª MSN Hotmail¡£http://www.hotmail.com/cn
Hi!
On Jan 02, Shane Allen wrote:
I checked the archives for this list and saw that in 2000 Sergei
recommended changing GWS_IN_USE to GWS_IDF to disable the 50%
weighting mechanism.
The MySQL manual, however says to change it from GWS_PROB to GWS_FREQ.
I'm inclined to go with the
I checked the archives for this list and saw that in 2000 Sergei recommended changing
GWS_IN_USE to GWS_IDF to disable the 50% weighting mechanism.
The MySQL manual, however says to change it from GWS_PROB to GWS_FREQ.
I'm inclined to go with the developer instead of documentation ;), but I'm
--- Stoyan [EMAIL PROTECTED] wrote: hi,
why don't you try to use this:
SELECT * FROM BOOK WHERE author LIKE '%charles%dickens%';
That query takes 6.4 seconds. My query (MATCH author AGAINST ('charles')
and match author against('dickens')) takes 1.3 seconds. Fulltext searching
is MUCH
Hi
I have posted this before. You can do an AND search by using the IF()
function.
Its messy in the query but it works.
Here an example of my select query - 3 inputs are checked as AND:
SELECT author, title, year, recommend, copy, publ_desc, publ_loc,
CEILING(IF(MATCH author AGAINST (
--- Colin Faber [EMAIL PROTECTED] wrote:
Ok,
The message set that I noticed this morning sparked my interest in this.
Currently I'm developing a search engine that will utilize mysql's
fulltext match technology. The problem that i've run into is, I can't
seem to find any
Hello Matthew,
I posted this earlier today but maybe you didnt get the message.
This definitely works for me, and its definitely an AND search (example):
SELECT author, title, year, recommend, copy, publ_desc, publ_loc,
CEILING(IF(MATCH author AGAINST ( 'Adams') 0, IF(MATCH title AGAINST
Ok,
The message set that I noticed this morning sparked my interest in this.
Currently I'm developing a search engine that will utilize mysql's
fulltext match technology. The problem that i've run into is, I can't
seem to find any documentation on how to force an AND search with in
MATCH
As of version 3.23.33 MySQL became attractive to deploy in our project
because it now includes (preliminary, though) support for full text
indeces. That is a GREAT advantage to prior versions. So,
congratulations for that feature, with that MySQL is definititly moving
on the right path and
Hi!
On Mar 12, Martin Rode wrote:
Now, unfortunately the FULLTEXT support as it stands right now has a few
drawbacks (all my tests where done with 3.23.33 and ~ 20 rows (~
60MB) in my test table.:
- searches for words with hits 100 are reasonably fast (1 sec.)
- searches with hits
Sergei Golubchik wrote:
Hi!
On Mar 12, Martin Rode wrote:
Now, unfortunately the FULLTEXT support as it stands right now has a few
drawbacks (all my tests where done with 3.23.33 and ~ 20 rows (~
60MB) in my test table.:
- searches for words with hits 100 are
19 matches
Mail list logo
