Hi,
I am trying to search for a word that contains special chars like ş
or ţ, but I find only the words and like when the special
chars are not a part of the word.
I found that if I search for ş (in boolean mode), I am able to
find the records that contain the
I have a problem with searching for a specific term. I have a database
of about 50k names, and am attempting to search the lastname field for
'self'. My query looks something like this:
SELECT * FROM users where MATCH (first_name, last_name) against ('self').
This query works fine if I use any
It isn't a reserved word, but self is a full-text stopword, so it isn't
indexed.
If you've built from source, the stopwords are in
path-to-source/myisam/ft_static.c
You can create your own stopword list, or turn off stopwords altogether, if
you want. See
I beleive this is the built-in word list file you were looking for. And the
word beyond was in the list. It would probably be helpful if there were
a SHOW command that listed the active built-in stopwords.
Ed
-
#include ftdefs.h
ulong ft_min_word_len=4;
ulong
Ok having some problems with MySQL's fulltext search. I have the fields
that I need fulltext indexed, everything seems to be working correctly, but
for some reason when I search for beyond looking for an item called:
Beyond Heaven yoga Day Spa
It doesn¹t find it.. I am searching in boolean
Check to see if beyond is in your stopword file.
-Original Message-
From: Richard Baskett [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 2:12 PM
To: MySQL
Subject: Fulltext searching
Ok having some problems with MySQL's fulltext search. I have the fields
that I need
PROTECTED] wrote:
Check to see if beyond is in your stopword file.
-Original Message-
From: Richard Baskett [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 2:12 PM
To: MySQL
Subject: Fulltext searching
Ok having some problems with MySQL's fulltext search. I have the fields
, Dathan Vance Pattishall at [EMAIL PROTECTED] wrote:
Check to see if beyond is in your stopword file.
-Original Message-
From: Richard Baskett [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 06, 2004 2:12 PM
To: MySQL
Subject: Fulltext searching
Ok having some problems with MySQL's fulltext
on 5/6/04 16:53, Michael Stassen at [EMAIL PROTECTED] wrote:
If you've built from source, the stopwords are in
path-to-source/myisam/ft_static.c
In my copy of 4.0.18, beyond is in the list.
You can create your own stopword list, or turn off stopwords altogether, if
you want. See
Joe Rhett wrote:
mysql select Notice_ID from Notices where match (Text) against
('+pollution +control' in boolean mode);
Empty set (0.00 sec)
mysql select Notice_ID from Notices where match (Text) against
('pollution control' in boolean mode);
Empty set (0.02 sec)
mysql select Notice_ID from
mysql select Notice_ID from Notices where match (Text) against
('+pollution +control' in boolean mode);
Empty set (0.00 sec)
mysql select Notice_ID from Notices where match (Text) against
('pollution control' in boolean mode);
Empty set (0.02 sec)
mysql select Notice_ID from Notices
Not a bug.
In the manual, section Upgrading from Version 3.23 to 4.0, there is
* To use `MATCH ... AGAINST (... IN BOOLEAN MODE)' with your tables,
you need to rebuild them with `REPAIR TABLE table_name USE_FRM'.
Based on a guess, or did you analyze the data file I sent?
And if
Hi!
On Jan 13, Joe Rhett wrote:
Not a bug.
In the manual, section Upgrading from Version 3.23 to 4.0, there is
* To use `MATCH ... AGAINST (... IN BOOLEAN MODE)' with your tables,
you need to rebuild them with `REPAIR TABLE table_name USE_FRM'.
Based on a guess, or did you
Based on a guess, or did you analyze the data file I sent?
Based on your data.
.. ..
And of course I tried this myself before writing to you :)
Cool. Thanks for the analysis.
And if so, may I suggest that the upgrade documentation REALLY needs to
be broken into
Hi!
On Jan 07, [EMAIL PROTECTED] wrote:
Description:
Boolean mode fulltext searching returns zero hits for valid queries.
How-To-Repeat:
Create a database with a Text column. Add a fulltext index on it.
Try to search for multiple words with AND or phrase syntax
[EMAIL PROTECTED] wrote:
Description:
Boolean mode fulltext searching returns zero hits for valid queries.
How-To-Repeat:
Create a database with a Text column. Add a fulltext index on it.
Try to search for multiple words with AND or phrase syntax.
Here are examples:
mysql select
Hi!
On Jan 07, [EMAIL PROTECTED] wrote:
Description:
Boolean mode fulltext searching returns zero hits for valid queries.
How-To-Repeat:
Create a database with a Text column. Add a fulltext index on it.
Try to search for multiple words with AND or phrase syntax.
I tried
Description:
Boolean mode fulltext searching returns zero hits for valid queries.
How-To-Repeat:
Create a database with a Text column. Add a fulltext index on it.
Try to search for multiple words with AND or phrase syntax.
Here are examples:
mysql select
Hi,
This isn't MySQL specific, but it's very interesting and I thought people
may be interested.
http://www.tbray.org/ongoing/When/200x/2003/07/30/OnSearchTOC
Cheers,
Andrew
SQL, Query
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
of interface to MySQL,
using the MySQL API).
-S
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 7:41 PM
To: [EMAIL PROTECTED]
Subject: Re: punctuation in fulltext searching
Daniel Rossi [EMAIL PROTECTED] wrote:
Hi i have just come across
Hi i have just come across an issue where a word is not being searched up if there is
any punctuation ie. AMROZI'S will not be search upon if you type AMROZI , please help
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Daniel Rossi [EMAIL PROTECTED] wrote:
Hi i have just come across an issue where a word is not being searched up if there
is any punctuation ie. AMROZI'S will not be search upon if you type AMROZI , please
help
Take a look at * operator which you can use in BOOLEAN MODE.
--
For technical
PROTECTED]
Sent: Tuesday, August 19, 2003 7:41 PM
To: [EMAIL PROTECTED]
Subject: Re: punctuation in fulltext searching
Daniel Rossi [EMAIL PROTECTED] wrote:
Hi i have just come across an issue where a word is not being searched up
if there is any punctuation ie. AMROZI'S will not be search upon
* m n
I have the following table with just one record! And when I do a select
statement, mysql returns no hits!!!
Would you explain to me what is wrong??
You have only one row.
URL: http://www.mysql.com/doc/en/Fulltext_Search.html
For very small tables, word distribution does not reflect
m n [EMAIL PROTECTED] wrote:
How fulltext is working!!?
From the MySQL manual:
The search for the word MySQL produces no results in the above example, because that
word is present in more than half the rows. As such, it is effectively treated as a
stopword (that is, a word with zero semantic
How fulltext is working!!?
I have the following table with just one record! And when I do a select
statement, mysql returns no hits!!!
Would you explain to me what is wrong??
Tanks
Cheers!
Adam
CREATE TABLE `mytest` (
`id` int(11) NOT NULL default '0',
`sub` text,
PRIMARY KEY
* m n
[...]
SELECT * FROM `mytest` WHERE (MATCH (sub) against (my));
... and short (default 4 characters) words are not indexed...
URL: http://www.mysql.com/doc/en/Fulltext_Fine-tuning.html
--
Roger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
Ralph Guzman wrote:
I have to do a catalog search through multiple tables and columns for
product model number, description, and name. I realize that doing
pattern matching with multiple LIKE statements is slow so I found that
FULLTEXT searches is a better alternative.
I have added a FULLTEXT
Ralph Guzman [EMAIL PROTECTED] wrote:
I have to do a catalog search through multiple tables and columns for
product model number, description, and name. I realize that doing
pattern matching with multiple LIKE statements is slow so I found that
FULLTEXT searches is a better alternative.
I
I have to do a catalog search through multiple tables and columns for
product model number, description, and name. I realize that doing
pattern matching with multiple LIKE statements is slow so I found that
FULLTEXT searches is a better alternative.
I have added a FULLTEXT index to the tables
Hi all.
I have a fulltext index on a table.
If I have the following fields:
field1,field2,field3,field4
Field4 being the fulltext field.
I have the following indices:
index1-field1,field2,field3
index2-fulltext field4
If I do a select:
select * from table where match(index2)
9.0 with MySQL 4.0.12-0.
I've hit something of a dead-end with fulltext searching and I don't
know where to look next.
I have a table that is about 1.5GB with about 400 records.
As you can tell, every record is about 4MB, all of which is
text.
I've created a fulltext index on the table
)
order by field1,field2,field3
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: H M Kunzmann [mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:33 AM
To: [EMAIL PROTECTED]
Subject: fulltext searching and query order question
Hi all.
I have a fulltext index on a table
Hi!
On Jun 13, H M Kunzmann wrote:
The answer is that a fulltext index can only be built on
a TEXT field. Even though the mysql documentation describes
MEDIUMTEXT and LONGTEXT fields as 'BLOB or TEXT field that can hold..',
they can not be used.
No, this is wrong.
Any xxxTEXT field can be
[mailto:[EMAIL PROTECTED]
Sent: Friday, June 13, 2003 10:33 AM
To: [EMAIL PROTECTED]
Subject: fulltext searching and query order question
Hi all.
I have a fulltext index on a table.
If I have the following fields:
field1,field2,field3,field4
Field4 being the fulltext field.
I
When mysql is indexing You can check your data file direcory and You
ca see that one file (the index) is growing in size.
I see it grow up to 8M and it stays there.
Watching this, it grows very slowly. After 5 minutes of indexing, the
file size has barely hit 2MB.
The command I use is:
Hello All.
I am using Redhat 9.0 with MySQL 4.0.12-0.
I've hit something of a dead-end with fulltext searching and I don't
know where to look next.
I have a table that is about 1.5GB with about 400 records.
As you can tell, every record is about 4MB, all of which is
text.
I've created
records (about 2k each) and all
works fine:
I rebuild index in minutes and the query needs only 1 or 2 seconds.
Santino
At 9:59 +0200 5-06-2003, H M Kunzmann wrote:
Hello All.
I am using Redhat 9.0 with MySQL 4.0.12-0.
I've hit something of a dead-end with fulltext searching and I don't
know where
create fulltext index Name on Table(field) i didnt get this
i usually do add fulltext field (field) i think , is that wrong ??
-Original Message-
From: Santino [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 6:14 PM
To: [EMAIL PROTECTED]
Subject: Re: REPOST: FULLTEXT searching
I think your index is corrupted because I expect a 1.5 GB index and not 8M!
You can see word list wit a utility (sorry I don't remember te name ft_dump).
I agree with this :-)
I suggest You to drop fulltext index, duplicate database and remove
some rrecords.
Then create index index again.
I'm implementing a search feature on one of my sites and I would like
to have a Google-style X is a very common word and was not included
in your search for stop words. I believe the stop words in fulltext
searching are dictated at compile time, so is there any way I can get
a list of current
Tim,
Thursday, September 19, 2002, 1:09:42 PM, you wrote:
TF I'm implementing a search feature on one of my sites and I would like
TF to have a Google-style X is a very common word and was not included
TF in your search for stop words. I believe the stop words in fulltext
TF searching are
sergei,
no i meant loading it up from raw data again. in the sense, i empty the
database, then i have a script which takes a directory full of files and reads
them into the database. each time i do that the database ends up corrupted.
is there any way to figure out where the corruption is? is
seem to work a lot better with the 4.0.2. And it won't crash with
special combinations of words :)
Erlend Stromsvik
-Original Message-
From: Marko Djukic [mailto:[EMAIL PROTECTED]]
Sent: 1. juli 2002 12:43
To: [EMAIL PROTECTED]
Subject: Re: fulltext searching
hi all...
i can't seem
Is there a tutorial or step-by-step introduction to fulltext searches with
MySQL somewhere?
Regards,
Eivind :-o
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
section 6.8 in the manual i think...
Quoting Eivind A. Sivertsen [EMAIL PROTECTED]:
Is there a tutorial or step-by-step introduction to fulltext searches with
MySQL somewhere?
Regards,
Eivind :-o
sql, query
Hi
If anybody from mysql is listening / watching, www.mysql.com is down, and
has been for a while.
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
section 6.8 in the manual i think...
Hmm, no; that's about the access privilege system...
I found it in section 24.2, but I feel this topic has gotten a bit scarce
mention in the manual.
Perhaps it deserves more than that...? I sure would appreciate something
extra :-)
Best regards,
Eivind,
Tuesday, July 02, 2002, 12:22:33 PM, you wrote:
EAS Is there a tutorial or step-by-step introduction to fulltext searches with
EAS MySQL somewhere?
Sure. In the MySQL manual:
http://www.mysql.com/doc/F/u/Fulltext_Search.html
--
For technical support contracts, goto
there's not a huge lot more to cover than what is in the manual... what exactly are
you looking for?
m.
Quoting Eivind A. Sivertsen [EMAIL PROTECTED]:
section 6.8 in the manual i think...
Hmm, no; that's about the access privilege system...
I found it in section 24.2, but I feel this
plus are you sure you're reading the latest manual? it is chapter 6.8.
try this (google cache of the mysql.com/doc since mysql.com seems to be down):
http://www.google.com/search?q=cache:yvsB86pbs5cC:www.mysql.com/doc/F/u/Fulltext_Search.html+full+text+mysqlhl=enie=UTF-8
ciao,
m.
Quoting
On Tue, 2 Jul 2002, Erlend Hopsø Strømsvik wrote:
Download the 4.0.2 source and compile it.
Things seem to work a lot better with the 4.0.2. And it won't crash with
special combinations of words :)
Hi,
Some things with BOOLEAN MODE seem still broken. Especially the '*'
jokers. I have
plus are you sure you're reading the latest manual? it is chapter 6.8.
The location was correct for the onlien manual. I first tried my stored PDf
version, since I could not reach http://www.mysql.com
There, it was section 24.2. Now I printed then online section 6.8 and will
go through it.
My
Hi!
On Jul 02, Thomas Spahni wrote:
On Tue, 2 Jul 2002, Erlend Hops? Str?msvik wrote:
Download the 4.0.2 source and compile it.
Things seem to work a lot better with the 4.0.2. And it won't crash with
special combinations of words :)
Hi,
Some things with BOOLEAN MODE seem still
hi all...
i can't seem to get the fulltext searching working perfectly... single search terms it
works fine, multiple search terms it also seems to be ok - finding records with any of
the search terms.
however, if i try the boolean mode it gives out garbage all the time. i try for
example
Hi!
On Jul 01, Marko Djukic wrote:
i can't seem to get the fulltext searching working perfectly... single
search terms it works fine, multiple search terms it also seems to be
ok - finding records with any of the search terms. however, if i try
the boolean mode it gives out garbage all
Hi!
On Feb 07, Alain Fontaine - Consultant and developer wrote:
-- snip --
select
BienID
from
biens
where
MATCH(Notes) AGAINST('+appartemen* -lux* -prop*' IN BOOLEAN MODE)
-- snip --
This does not produce the correct result, whereas this does:
-- snip --
select
BienID
Hello,
I am evaluating mySQL 4.0.1-alpha on Redhat Linux 7.2 (RPM version). I am
playing with the new fulltext search features and I have a question
regarding the syntax...
I have created a fulltext index on a field 'Notes'. I'd like to search for
records that have words starting with
Hello,
I am evaluating mySQL 4.0.1-alpha on Redhat Linux 7.2 (RPM version). I am
playing with the new fulltext search features and I have a question
regarding the syntax...
I have created a fulltext index on a field 'Notes'. I'd like to search for
records that have words starting with
A relatively straightforward way round this - and a number of other problems
with FULLTEXT - is to combine a full text search with a LIKE criterion to
narrow the results. Example (assuming that you are searching a table called
Documents on a TEXT field called Term):
SELECT * FROM Documents WHERE
--- 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
I read through the MySQL documentation on full text indexing, and there
does not seem to be a way to search for a *phrase*, e.g. searching for
a document that contains "Sailor Moon", as opposed to one that contains
the word "Sailor" and the word "Moon", not necessarily together. (Unless I
use
-
From: Philip Mak [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 18, 2001 5:39 PM
To: [EMAIL PROTECTED]
Subject: Phrase based fulltext searching
I read through the MySQL documentation on full text indexing, and there
does not seem to be a way to search for a *phrase*, e.g. searching for
a document
/mySQL --with-mysqld-user=mysql
Perl: This is perl, version 5.005_03 built for i386-linux
==
We were attempting some simple tests on MySQL fulltext searching, using the
documentation provided on www.mysql.com as a starting point. Our session was
as follows:
mysql
Hi!
mysql SELECT *,MATCH a,b AGAINST ('collections support') as x FROM t;
+--++--+
| a| b | x|
69 matches
Mail list logo