fulltext searching using special chars

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

Re: Strange issue with fulltext searching (is "self" reserved)?

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

Strange issue with fulltext searching (is "self" reserved)?

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 o

RE: Fulltext searching

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 ft_ma

Re: Fulltext searching

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. S

Re: Fulltext searching

Thanks! Rick on 5/6/04 15:30, 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

Re: Fulltext searching

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 >

RE: Fulltext searching

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.

Fulltext searching

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 boolea

Re: Bug in Boolean mode fulltext searching.

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 f

Re: Bug in Boolean mode fulltext searching.

> > 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 broke

Re: Bug in Boolean mode fulltext searching.

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

Re: Bug in Boolean mode fulltext searching.

> 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

Re: Bug in Boolean mode fulltext searching.

> >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 No

Re: Bug in Boolean mode fulltext searching.

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

Re: Bug in Boolean mode fulltext searching.

[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

Re: Bug in Boolean mode fulltext searching.

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

Bug in Boolean mode fulltext searching.

>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&g

A series of essays on fulltext searching.

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:http://lis

Re: punctuation in fulltext searching

temmer (assuming you're building some kind 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 sear

RE: punctuation in fulltext searching

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

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 if you type AMROZI , please > help Take a look at * operator which you can use in BOOLEAN MODE. -- For techni

punctuation in fulltext searching

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:http://lists.mysql.com/[EMA

Re: fulltext searching

* m n [...] > SELECT * FROM `mytest` WHERE (MATCH (sub) against ("my")); ... and short (default < 4 characters) words are not indexed... http://www.mysql.com/doc/en/Fulltext_Fine-tuning.html > -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscri

fulltext searching

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 (`id`

Re: fulltext searching

"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 sema

Re: fulltext searching

* 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. http://www.mysql.com/doc/en/Fulltext_Search.html > "For very small tables, word distribution does not reflect a

Re: FULLTEXT Searching

"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.

Re: FULLTEXT Searching

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 in

FULLTEXT Searching

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 I'm

RE: fulltext searching and query order question

ards, > 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. >

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

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

RE: fulltext searching and query order question

('word1 word2' in boolean mode) 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

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

; 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 i

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 have the following indices: index1->field1,field2,field3 index2->fulltext field4 If I do a select: select * from table where match(index2) aga

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

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

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

> 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 aga

RE: REPOST: FULLTEXT searching help needed. Please somebody help.

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

Re: REPOST: FULLTEXT searching help needed. Please somebody help.

0.000 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&#x

REPOST: FULLTEXT searching help needed. Please somebody help.

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&#x

re: Fulltext searching - getting list of stop words?

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

Fulltext searching - getting list of stop words?

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

Re: fulltext searching / BUG report

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 it

Re: fulltext searching / BUG report

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 s

Re: fulltext searching

> 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

RE: fulltext searching / BUG report

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 4.

Re: fulltext searching

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+mysql&hl=en&ie=UTF-8 ciao, m. Quoting "E

Re: fulltext searching

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

Re: Re: fulltext searching

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 https://

Re: fulltext searching

> 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,

RE: fulltext searching

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] te

Re: fulltext searching

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

Re: fulltext searching

Is there a tutorial or step-by-step introduction to fulltext searches with MySQL somewhere? Regards, Eivind :-o - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.

RE: fulltext searching

hings 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

Re: fulltext searching

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 give

Re: fulltext searching

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 examp

mySQL 4 - FullText searching syntax?

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 "app

Re: mySQL 4 - FullText searching syntax?

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

Re: mySQL 4 - FullText searching syntax?

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

mySQL 4 - FullText searching syntax?

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 "app

RE: Phrase based fulltext searching

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

Re: More questions about Fulltext searching.

--- 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('

Re again: More questions about Fulltext searching.

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 ('P

Re: More questions about Fulltext searching.

--- 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 docu

Re: More questions about Fulltext searching.

>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 AGAINS

More questions about Fulltext searching.

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 AGAIN

RE: Phrase based fulltext searching

al Message- 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

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 that contains "Sailor Moon", as opposed to one that contains the word "Sailor" and the word "Moon", not necessarily together. (Unless I use LIKE

Re: Problems with MySQL fulltext searching.

Hi! > > mysql> SELECT *,MATCH a,b AGAINST ('collections support') as x FROM t; > +--++--+ > | a| b | x| > +--++

Problems with MySQL fulltext searching.

ot root 178 Feb 29 2000 /usr/lib/libc.so Configure command: ./configure --prefix=/home/mysql/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 searc