Re: Fulltext Match BOOLEAN MODE not searching integers

Hi I found by using the REPAIR command it is now working. Thanks, Neil On Wed, Mar 31, 2010 at 5:38 PM, Tompkins Neil wrote: > Hi Mark > > I did infact change the value of ft_min_word_len to 1. Rebuild the indexes > using REPAIR table name. But it didn't appear to have any affect. > > Cheers

Re: Fulltext Match BOOLEAN MODE not searching integers

Hi Mark I did infact change the value of ft_min_word_len to 1. Rebuild the indexes using REPAIR table name. But it didn't appear to have any affect. Cheers Neil On Wed, Mar 31, 2010 at 5:29 PM, Mark Goodge wrote: > On 31/03/2010 16:52, Tompkins Neil wrote: > >> Hi >> >> I have the following

Re: Fulltext Match BOOLEAN MODE not searching integers

On 31/03/2010 16:52, Tompkins Neil wrote: Hi I have the following fulltext search which appears to work fine for string phrases. However if I search like just "51" which is part of the string name like 51 Blue Widget in the table it doesn't return any results. However if I search like "bl" it r

RE: Fulltext index -first query slow, subsequent queries fast

> -Original Message- > From: Ananda Kumar [mailto:[EMAIL PROTECTED] > Sent: Friday, June 13, 2008 10:48 AM > To: [EMAIL PROTECTED] > Cc: mos; mysql@lists.mysql.com > Subject: Re: Fulltext index -first query slow, subsequent queries fast > > Hi > > Is sphi

Re: Fulltext index -first query slow, subsequent queries fast

Hi Is sphinxsearch avialable only on for windows regards anandkl On 6/13/08, Rory McKinley <[EMAIL PROTECTED]> wrote: > > mos wrote: > > >> Why not switch to Sphinx full text search for MySQL? It is faster and can >> handle more data than MySQL's built in fulltext search. >> http://www.sphinxsea

Re: Fulltext index -first query slow, subsequent queries fast

mos wrote: Why not switch to Sphinx full text search for MySQL? It is faster and can handle more data than MySQL's built in fulltext search. http://www.sphinxsearch.com/ Mike I have read about sphinx and the good performance boost it provides - unfortunately there is a lot of legacy code

Re: Fulltext index -first query slow, subsequent queries fast

At 02:20 PM 6/12/2008, you wrote: Hi List I have a table with a fulltext index across five fields, with about 2.2 million records and a data size of about 5.6 GB (index another 3.5 GB). When I test a query that uses fulltext matching, the first run takes about 15-16 seconds to complete. The s

RE: Fulltext index -first query slow, subsequent queries fast

>From: Rory McKinley [mailto:[EMAIL PROTECTED] >Sent: Thursday, June 12, 2008 4:57 PM >To: Jerry Schwartz; mysql >Subject: Re: Fulltext index -first query slow, subsequent queries fast > >Jerry Schwartz wrote: >> File system, or disk caching, uses some kind of algorithm to

Re: Fulltext index -first query slow, subsequent queries fast

Jerry Schwartz wrote: File system, or disk caching, uses some kind of algorithm to hold chunks of files in system RAM. That way a program can get to it more quickly than if it had to go out to the disk. The algorithms vary, depending upon the smarts of the program and the smarts of the file syste

RE: Fulltext index -first query slow, subsequent queries fast

>-Original Message- >From: Rory McKinley [mailto:[EMAIL PROTECTED] >Sent: Thursday, June 12, 2008 3:20 PM >To: mysql >Subject: Fulltext index -first query slow, subsequent queries fast > >Hi List > >I have a table with a fulltext index across five fields, with about 2.2 >million records and

Re: Fulltext Relevancy not returning anticipated results?

VIOLA! As it turns out, the cnf file that I was shown was the cnf file on the OLD server that we used when we had DB/Webserver combined on one server - that conf was not updated for the new separate DB server. Thanks muchly all, that change made the search work as expected!!! Thanks for the star

Re: Fulltext Relevancy not returning anticipated results?

Mike, Mike Morton wrote: OK - I am at a total loss here :) We have added an addition fulltext field with the highest rating: match(search_keywords) against ('vic*' IN BOOLEAN MODE) * 16 And verified that in that field, there is indeed a keyword "vic" - but still - that result is not returned,

Re: Fulltext Relevancy not returning anticipated results?

> > 860.674.8796 / FAX: 860.674.8341 > > www.the-infoshop.com > www.giiexpress.com > www.etudes-marche.com > >> -Original Message- >> From: Mike Morton [mailto:[EMAIL PROTECTED] >> Sent: Tuesday, October 30, 2007 9:56 AM >> To: Jerry Schw

RE: Fulltext Relevancy not returning anticipated results?

age- > From: Mike Morton [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 30, 2007 9:56 AM > To: Jerry Schwartz; mysql@lists.mysql.com > Subject: Re: Fulltext Relevancy not returning anticipated results? > > Jerry: > > Sorry - I should have mentioned in my previous email that w

Re: Fulltext Relevancy not returning anticipated results?

Jerry: Sorry - I should have mentioned in my previous email that we have changed that min. word length to 2 in the config already, as we have MANY 3 letter searches... ;) Any other suggestions? On 10/30/07 9:12 AM, "Jerry Schwartz" <[EMAIL PROTECTED]> wrote: > By default, MySQL ignores any "wo

RE: Fulltext Relevancy not returning anticipated results?

By default, MySQL ignores any "word" with less than four characters when doing full text searches. You can change this in my.conf, the setting should be obvious. I had to do this so that customers could find inventory items that were red. Regards, Jerry Schwartz The Infoshop by Global Informatio

Re: Fulltext Index / Index .. both?

Justin wrote: I'm wanting to add a new field to my table that I will both be grouping by, searching with full text hits and plain likes.. I know I'll need a FULL TEXT index, but will that full text index also index like a normal index will? or should I also add an index too.. You'll need to ad

RE: fulltext search option

So far as I know, the only way to accomplish what you want is to do what you tried: put the Boolean match in the WHERE clause and order by a natural match. That's what I do on our web site. By the way, you can't use prefix stemming: "*abcd" is the same as "abcd". Regards, Jerry Schwartz The Info

RE: fulltext substringsearches?

Sorry, you can't use a preceding asterisk. It is annoying. The only alternative is to use a LIKE operator. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -Original Message- > From: Philipp Wabinski [ma

Re: FullText Scoring With Two Databases

-BEGIN PGP SIGNED MESSAGE- Hash: SHA512 Neil, The short answer is probably "merge the two databases manually and rebuild the index". I don't think there's any real answer otherwise. Given the old version of MySQL you aren't going to be able to do anything fancy like federating the two t

Re: Fulltext relevance and weighting....

Guys, I doubt I'd qualify as an expert but here's my two pence worth ( ;^) )I wrote a search engine a while back that relies heavily on full-text searching and the three things I found that improved results were... 1) Precisely what Dan explains, doing extra biasing per field in the SQL wi

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)

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. The asterisk operator is only valid at the end of a word. Those initial asterisks, and the quotation marks, would be treat

Re: Fulltext relevance and weighting....

In the last episode (Jan 31), Mike Morton said: > Mike: > > :) I wish! Free ham for everyone! > > I had already changed the min length to 2 actually - so that is not the > affecting factor... > > It is more of an issue to prioritizing fields for relevance, and whether it > is possible to do th

Re: Fulltext relevance and weighting....

Mike: :) I wish! Free ham for everyone! I had already changed the min length to 2 actually - so that is not the affecting factor... It is more of an issue to prioritizing fields for relevance, and whether it is possible to do this within a fulltext query, or whether it needs to be done through

Re: Fulltext relevance and weighting....

Mike, It's likely because MySQL fulltext index defaults to a word length of 4 characters or more. So "Ham" probably is not being indexed. You will need to change the minimum word length. See http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html Mike (P.S. Send me a free ham

RE: Fulltext problem

With so few rows, are you hitting the 50% rule? Try again with a decent number of rows. > -Original Message- > From: devy [mailto:[EMAIL PROTECTED] > Sent: Thursday, January 04, 2007 5:46 AM > To: mysql@lists.mysql.com; [EMAIL PROTECTED] > Subject: Fulltext problem > > Hi, > today I've

re: Fulltext problem

Hi Devy -- There are a couple of issues with your query below, and hopefully we can help you figure it out. First off, your table and query structure are fine. However, one can ask why not use a TINYTEXT or even a TEXT field instead of VARCHAR(255). It's all in the memory overhead. =) Moving

Re: Fulltext problem

devy wrote: ---cut--- - insert into ft_test (field1,field2,field3) VALUES('mysql full text', 'this is a test', 'mysql fulltext'); - the problem is that when I execute this query I always get 0 as relevance: ---cut--- A FULLTEXT search will not match return val

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

Re: FULLTEXT index help

Horst Azeglio wrote: I'm trying to do a MySQL Query but it doesn't work. MySQL version: 4.0.26 When I put only one argument in MATCH, it shows no error but doesn't return anything [quote] SELECT * FROM item WHERE MATCH (nom) against ('Huile');[/quote] or [quote]SELECT * FROM item WHERE MATCH (n

Re: Fulltext search for term 'c++'

I think the '+' will not get into the index in the first place. So, there's probably no way to get a search to use the index. However if you want a consistant query format for your search you could probably get the correct result by wrapping the search term in double quotes: select f1 from t1 w

RE: Fulltext 3 letter words

years! -Original Message- From: James Harvard [mailto:[EMAIL PROTECTED] Sent: Monday, 24 April 2006 10:11 PM To: mysql@lists.mysql.com Subject: Re: Fulltext 3 letter words You can find out whether the server has picked up the changes from your configuration file by running the following

Re: Fulltext 3 letter words

You can find out whether the server has picked up the changes from your configuration file by running the following SQL: show variables like 'ft_min_word_len'; As per the instructions in the manual http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html you must rebuild the indexes on

Re: Fulltext 3 letter words

is free of errors, virus or > interference. > Commerce Engine Pty Ltd ACN 118 850 552 > > > -Original Message- > From: Prasad [mailto:[EMAIL PROTECTED] > Sent: Monday, 24 April 2006 1:51 PM > To: [EMAIL PROTECTED] > Subject: Re: Fulltext 3 letter words > >

RE: Fulltext 3 letter words

ained nor that the communication is free of errors, virus or interference. Commerce Engine Pty Ltd ACN 118 850 552 -Original Message- From: Prasad [mailto:[EMAIL PROTECTED] Sent: Monday, 24 April 2006 1:51 PM To: [EMAIL PROTECTED] Subject: Re: Fulltext 3 letter words Hi Taco Fleur., Whe

RE: Fulltext 3 letter words

MAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: Fulltext 3 letter words > > Taco Fleur wrote: >> Hi all, >> >> I know I asked this question before and I do apologise for having to >> ask again, but I have not been able to get this to work for us. >> I modi

Re: Fulltext 3 letter words

Taco Fleur wrote: Hi all, I know I asked this question before and I do apologise for having to ask again, but I have not been able to get this to work for us. I modified the config file (there were many in the folder, not sure whether I modified the right one) restarted the whole machine sinc

RE: Fulltext 3 letter words

0 552 -Original Message- From: John Hicks [mailto:[EMAIL PROTECTED] Sent: Monday, 24 April 2006 12:28 PM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: Fulltext 3 letter words Taco Fleur wrote: > Hi all, > > I know I asked this question before and I do apologise for having t

Re: Fulltext 3 letter words

Taco Fleur wrote: Hi all, I know I asked this question before and I do apologise for having to ask again, but I have not been able to get this to work for us. I modified the config file (there were many in the folder, not sure whether I modified the right one) restarted the whole machine since t

RE: fulltext wildcards

ql.com Subject: Re: fulltext wildcards Try: http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html -- Gabriel PREDA Senior Web Developer

Re: fulltext wildcards

Try: http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html -- Gabriel PREDA Senior Web Developer

RE: Fulltext and reserved words

opies first, untill you are sure what you are doing. HTH Keith In theory, theory and practice are the same; in practice they are not. On Thu, 13 Apr 2006, Taco Fleur wrote: > To: [EMAIL PROTECTED], mysql@lists.mysql.com > From: Taco Fleur <[EMAIL PROTECTED]> > Subject: RE: F

RE: Fulltext and reserved words

omain Registration, .COM for as low as fifteen dollars a year, .COM.AU for fifty dollars two years! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 April 2006 4:41 PM To: mysql@lists.mysql.com Subject: RE: Fulltext and reserved words Hi Taco - intere

RE: Fulltext and reserved words

his list. Regards Keith In theory, theory and practice are the same; in practice they are not. On Thu, 13 Apr 2006, Taco Fleur wrote: > To: mysql@lists.mysql.com > From: Taco Fleur <[EMAIL PROTECTED]> > Subject: RE: Fulltext and reserved words > > Thanks for that, you

RE: Fulltext and reserved words

mysql@lists.mysql.com Subject: Re: Fulltext and reserved words In the last episode (Apr 12), Taco Fleur said: > I am in need to search for sql reserved words with MATCH AGAINST it > turns it doesn't return anything when I feed it a reserved word like > 'sql' is there anyt

Re: Fulltext and reserved words

In the last episode (Apr 12), Taco Fleur said: > I am in need to search for sql reserved words with MATCH AGAINST it > turns it doesn't return anything when I feed it a reserved word like > 'sql' is there anything I can do about that? By default the full-text indexer skips words less than four cha

Re: fulltext searches

Hi Octavian, Yes indeed... "IT" is a stop word... despite being the acronym for "Information Technology"... *It* is a third-person neuter pronounin the English language. You can make it "IT" a normal word by excluding it from the build-in stop word list

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

Re: Fulltext boolean search and the asterix

Paul DuBois wrote: At 10:49 +0100 11/8/05, Jigal van Hemert wrote: Lindsey wrote: but do you know how to use the * in regexp searches. err what i mean if i want to search for * and not use it as asterix? " To use a literal instance of a special character in a regular expression, precede it by

Re: Fulltext boolean search and the asterix

At 10:49 +0100 11/8/05, Jigal van Hemert wrote: Lindsey wrote: ok thanks, then i know! but do you know how to use the * in regexp searches. err what i mean if i want to search for * and not use it as asterix? i have tried \* but that did't work, it just does the same as *. The manual comes

Re: Fulltext boolean search and the asterix

Lindsey wrote: ok thanks, then i know! but do you know how to use the * in regexp searches. err what i mean if i want to search for * and not use it as asterix? i have tried \* but that did't work, it just does the same as *. The manual comes again to the rescue ;-) Appendix G [1] tells us:

Re: Fulltext boolean search and the asterix

ok thanks, then i know! but do you know how to use the * in regexp searches. err what i mean if i want to search for * and not use it as asterix? i have tried \* but that did't work, it just does the same as *. Quoting Jigal van Hemert <[EMAIL PROTECTED]>: > Lindsey wrote: > > Lets say the tabl

Re: Fulltext boolean search and the asterix

Lindsey wrote: Lets say the table contains the following brands SAMSUNG SIEMENS SONY If you do a fulltext boolean search with the term: -S*Y -(S*Y) everyting that starts with an S will be excluded... any solutions? Although I couldn't find a question in your post, I guess you want to know h

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 "words" (My

RE: Fulltext behavior in 3.23.58

Nitzan, In the unlikely event that you can recompile but not upgrade, you could add your common words to the full text stopword list in myisam/ft_static.c and rebuild mysql. Otherwise, this might be helpful http://lists.mysql.com/mysql/132649 Andy > -Original Message- > From: nitzan sha

Re: fulltext max size

Yui Hiroaki <[EMAIL PROTECTED]> wrote on 08/24/2005 12:38:18 PM: > Thank you for your reply. > > > sql>create table (test title longtext)TYPE=MyISAM; > > sql>alter table test add fulltext (title); > > Your SQL above does not define the word long. How much > character can I insert into "title"

Re: fulltext max size

Thank you for your reply. > sql>create table (test title longtext)TYPE=MyISAM; > sql>alter table test add fulltext (title); Your SQL above does not define the word long. How much character can I insert into "title" column? Yui What do you expedt the number in brackets to do? I cannot find any

Re: fulltext max size

Yui Hiroaki <[EMAIL PROTECTED]> wrote on 24/08/2005 10:57:20: > I created table for fulltext. I publish SQL: > > sql>create table (test title longtext)TYPE=MyISAM; > sql>alter table test add fulltext title (4); > > > But title is so small to insert text. > what biggest text I can insert tit

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 is high and a desireable e

Re: fulltext/boolean search

Hi! Check the manual for ft_boolean_syntax variable. It defines what character is used for every operator. Space marks "default" operator - so you can change it. On Jun 06, Sebastian wrote: > I created a search app with fulltext, boolean, etc. i have two forms, > one that allows the user to jus

RE: Fulltext Simple Question

es it go? > > Thanks, > Scott > > > > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 25, 2005 2:21 PM > To: Brian Mansell > Cc: mysql@lists.mysql.com; Scott Purcell > Subject: Re: Fulltext Simple Qu

RE: Fulltext Simple Question

use mysql from a binary install, and I am just learning it. How do I create this file, and where does it go? Thanks, Scott -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 25, 2005 2:21 PM To: Brian Mansell Cc: mysql@lists.mysql.com; Scott Pur

Re: Fulltext Simple Question

Brian Mansell <[EMAIL PROTECTED]> wrote on 05/25/2005 03:09:03 PM: > Scott - > > Check this excerpt out ( > http://dev.mysql.com/doc/mysql/en/fulltext-search.html ) from the MySQL > Documentation. I hope it helps! > > --bemansell > > ... > > "Every correct word in the collection and in the q

Re: Fulltext Simple Question

Scott - Check this excerpt out ( http://dev.mysql.com/doc/mysql/en/fulltext-search.html ) from the MySQL Documentation. I hope it helps! --bemansell ... "Every correct word in the collection and in the query is weighted according to its significance in the collection or query. This way, a wo

RE: Fulltext boolean question

Oh hey, very cool - thanks. I was assuming that + and AND were the same thing, guess not =) -Ed -Original Message- From: Chris [mailto:[EMAIL PROTECTED] Sent: Friday, March 25, 2005 4:21 PM To: mysql@lists.mysql.com Subject: Re: Fulltext boolean question Try using: "+dragon

Re: Fulltext boolean question

Try using: "+dragon +ice +blue" I'm fairly sure that's in the FULLTEXT search portion of the online docs. Chris Ed Lazor wrote: Hi, How can I limit the results of a fulltext search to the entries that only have the keywords I'm searching for? I'm searching the title field of a product database and

Re: Fulltext In Boolean Wildcard Questions

From: "Freddie Bingham" <[EMAIL PROTECTED]> > > (1) Why is such a query as this allowed? > > > > WHERE MATCH (text) > > AGAINST ('+s*' IN BOOLEAN MODE) > > > > This returns everything that starts with an 's', as expected > > by the syntax. > > Why is it not stopped by the mysql minimum word length?

RE: Fulltext In Boolean Wildcard Questions

It appears my email client took some liberties with converting portions of my queries into mailto links. I've fixed them below. Sorry! > I have a few questions about wildcard usage with Fulltext > searches (Mysql 4.1.9). I have tried to find relevant answers > to these questions with no success.

Re: FullText StopWordFile

Hello. > Is the build in one for english only ? On my Linux system with utf8 locale it works perfectly with russian words. As the format of the file you may use such where every word begins with a new line. "Gabriel PREDA" <[EMAIL PROTECTED]> wrote: > How internationalized is the ft_s

Re: FULLTEXT Exact phrase search including quotes

Hello. >and I want to search for this exact phrase, including double quotes, You can't do this, because fulltext search operates with "words", and double quotes not a "word". Also an order of the sequence of words doesn't have a sence for a fulltext search. CheHax <[EMAIL PROTECT

Re: FULLTEXT Exact phrase search including quotes

Alright, my example phrase wasn't a good one. Let's try this now: We have a table with company activities. On of them is : "Plastique ou carton" and some others are in "Plastic, carton" Plastique <> Plastic (different language) What we want, is to find exactly "Plastique ou carton" and not the o

Re: FULLTEXT Exact phrase search including quotes

Hello. At first: from your phrase with default values for the FULLTEXT parameters there is the only one meaningful word - football. Because 'I', 'on', 'TV' has less than 3 characters. 'like' is in the stopword list. Quotes '"' - are skipped from the search. What query do you use to search? D

Re: FULLTEXT index on InnoDB tables (looking for a workaround)

All, - Original Message - From: "mos" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Sunday, January 30, 2005 6:29 AM Subject: Re: FULLTEXT index on InnoDB tables (looking for a workaround) At 02:32 PM 1/28/2005, you wrote: And, of course, another opti

Re: FULLTEXT index on InnoDB tables (looking for a workaround)

At 02:32 PM 1/28/2005, you wrote: And, of course, another option is to contact Heikki and coax him into hiring somebody to add FULLTEXT to InnoDB tables. And bring lots of cash with you. :-) I've pestered Heikki a couple of years ago and he's willing to do it only if there is someone willing to f

Re: FULLTEXT index on InnoDB tables (looking for a workaround)

symbulos partners wrote: Thanks for the extremely useful answer. Some comments, questions here below. On Friday 28 Jan 2005 16:38, you wrote: No, only the BLOB/TEXT columns need to be moved to MyISAM. Yes, I thought of doing so. The drawback is that you de-normalise the database. Is that correct?

Re: FULLTEXT index on InnoDB tables (looking for a workaround)

symbulos partners wrote: Is there any other workaround? The reason because we are using InnoDB is because there s full support - for foreign keys, - for joint queries - for rollback on commit Does anybody know any other way of indexing the table in a way, which would allow full text search?

Re: FULLTEXT index on InnoDB tables (looking for a workaround)

Thanks for the extremely useful answer. Some comments, questions here below. On Friday 28 Jan 2005 16:38, you wrote: > No, only the BLOB/TEXT columns need to be moved to MyISAM. Yes, I thought of doing so. The drawback is that you de-normalise the database. Is that correct? There are 2 alterna

Re: FULLTEXT index on InnoDB tables (looking for a workaround)

Thanks for the extremely useful answer. Some comments, questions here below. On Friday 28 Jan 2005 16:38, you wrote: > No, only the BLOB/TEXT columns need to be moved to MyISAM. Yes, I thought of doing so. The drawback is that you de-normalise the database. Is that correct? There are 2 alterna

Re: FULLTEXT index on InnoDB tables (looking for a workaround)

> > > As you have noticed - you cannot. > > > > > > So, all you can do is creating a MyISAM table and copying > > > the column contents. > > > > Are you suggesting to have a full copy of the table in MyISAM format? > > No, only the BLOB/TEXT columns need to be moved to MyISAM. > > > > > Is there a

Re: FULLTEXT index on InnoDB tables (looking for a workaround)

symbulos partners <[EMAIL PROTECTED]> wrote on 01/28/2005 11:14:00 AM: > On Friday 28 Jan 2005 15:41, you wrote: > > As you have noticed - you cannot. > > > > So, all you can do is creating a MyISAM table and copying > > the column contents. > > Are you suggesting to have a full copy of the table

Re: FULLTEXT index on InnoDB tables (looking for a workaround)

On Friday 28 Jan 2005 15:41, you wrote: > As you have noticed - you cannot. > > So, all you can do is creating a MyISAM table and copying > the column contents. Are you suggesting to have a full copy of the table in MyISAM format? Is there any other workaround? The reason because we are using Inn

Re: FULLTEXT index on InnoDB tables

Hello, > I would need to index FULLTEXT two columns in a InnoDB table. How do you solve > the problem? As you have noticed - you cannot. So, all you can do is creating a MyISAM table and copying the column contents. With regards, Martijn Tonies Database Workbench - developer tool for InterBase

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 sequence of true word characters (letters, digits

Re: Fulltext search string less than 4 characters

Lee, establish the fulltext minimum word length system variable as follows... [mysqld] ft_min_word_len=3 reference: http://dev.mysql.com/doc/mysql/en/Fulltext_Fine-tuning.html cheers, --bemansell Brian E. Mansell MySQL Professional On Thu, 06 Jan 2005 20:59:23 -0500, leegold <[EMAIL PROTEC

Re: Fulltext + order by strategy

[EMAIL PROTECTED] wrote: Since you are already splitting your data into "fulltext columns" and "other data" I would keep that design. Others on the list have greatly improved their performance by running their tables in this same fashion. If by some chance your "non-fulltext" columns are all fix

Re: Fulltext + order by strategy

Since you are already splitting your data into "fulltext columns" and "other data" I would keep that design. Others on the list have greatly improved their performance by running their tables in this same fashion. If by some chance your "non-fulltext" columns are all fixed width, there is anoth

Re: Fulltext insert/update

Hi! On Nov 15, John Smith wrote: > I know that having a fulltext index on a table slows inserts and updates > down (or I think I do...might have miss read something) > > I have a large table that uses fulltext which I plan to update nearly > 90% of the rows (400,00+) and add new ones. > > It cur

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

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

Try to search in keyword table: select * from keywords WHERE MATCH(keyword_txt) AGAINST ('$radio_keyword' IN BOOLEAN MODE); If it works the problem is in the join. Santino $query = "SELECT page.* FROM `page` LEFT JOIN `keywords` USING (`page_id`) WHERE MATCH (`keywords`.`keyword_txt`) AGAINST ('$

RE: Fulltext Search help

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

RE: Fulltext Search help

leegold on Friday, October 15, 2004 2:32 PM said: > I do fulltext search on "work". And AFAIK the search will not find > "work". For that matter the seach will not find "ingm". How do I > implement in MYSQL/PHP a search that will have this action? please share the c

RE: fulltext search

> -Original Message- > - If you use one word in your search, 1 is a probable score, because all > the results that > appear have the same relevance (they all contain that word!). > - If you use two words, where the second isn't present in all results, you > shouldn't get > relevance value 1

  1   2   3   4   5   >