Re: Small issue with FULLTEXT searches

Chris, The index on (Dep, Des) is not a full-text index. If you use SHOW CREATE TABLE, I think this becomes much easier to see at a glance. - Baron On Thu, Apr 29, 2010 at 8:10 AM, Chris Knipe wrote: > Hi List, > > Table structure: > mysql> DESCRIBE FlightRoutes; > +-++

Small issue with FULLTEXT searches

Hi List, Table structure: mysql> DESCRIBE FlightRoutes; +-++--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +-++--+-+-+---+ | EntryID | char(36) | NO | PRI | NULL| | | Dep | varcha

FULLTEXT searches with hyphens.

Does anyone know how to get FULLTEXT indexing not to treat hyphens as word breaks? Basically I am searching part numbers and descriptions and need something like Z-5500 to be returned. I want to keep using FT for the scoring. I lowered the min word length to 2. I am thinking I could lower it

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

fulltext searches

Hi, I have tried: select title from table where match(title, body) against('IT' in boolean mode); The result was 0 records. I have checked the min word lenght which is allowed with: mysql> show variables like '%ft_min_word_len%'; +-+---+ Variable_name | Value | +---

Re: Please help me: Boolean fulltext searches, AND instead of OR

John thegimper wrote: This is what i need: Posted by gogman on Monday May 5 2003, @10:42am on the mysql website: MySQL defaults to an 'OR'. Example: 'dog cat' = 'dog OR cat'. Most fulltext search engines default to an 'AND'. These include: AltaVista, Fast Search, G

Re: Please help me: Boolean fulltext searches, AND instead of OR

efaults to AND instead of OR. > > Almost every search engine i have tried, google etc. works like this. > > "black horse cat dog" only show results with all words present. > > > > This is what i did, set global ft_boolean_syntax = ' +-><()~*:""&|' &

Re: Please help me: Boolean fulltext searches, AND instead of OR

7; > > I really appreciate your help!! > > >From: Sergei Golubchik <[EMAIL PROTECTED]> > >To: Jessica Svensson <[EMAIL PROTECTED]> > >CC: [EMAIL PROTECTED] > >Subject: Re: Please help me: Boolean fulltext searches, AND instead of > OR > >Date: Wed,

Re: Please help me: Boolean fulltext searches, AND instead of OR

> > This is what i did, set global ft_boolean_syntax = ' +-><()~*:""&|' > > I really appreciate your help!! > > >From: Sergei Golubchik <[EMAIL PROTECTED]> > >To: Jessica Svensson <[EMAIL PROTECTED]> > >CC: mysql@list

Re: Please help me: Boolean fulltext searches, AND instead of OR

t dog" only show results with all words present. This is what i did, set global ft_boolean_syntax = ' +-><()~*:""&|' I really appreciate your help!! From: Sergei Golubchik <[EMAIL PROTECTED]> To: Jessica Svensson <[EMAIL PROTECTED]> CC: mysql@lists.mys

Re: Please help me: Boolean fulltext searches, AND instead of OR

Hi! On Mar 23, Jessica Svensson wrote: > Is there any way i can get results with AND instead of OR? > Trying to search for "black cat" should only return records that contains > both black and cat. > > I'm using the following code to get my result: > > SELECT * FROM `searchtbl` WHERE MATCH (tex

Re: Please help me: Boolean fulltext searches, AND instead of OR

I couldn't find much on the variable you were trying to change. Although it may have changed and now be called ft_boolean_syntax. But that still won't help you since it doesn't appear to have an option to change the default separator. I think you will need to add the + to each word if you want t

Please help me: Boolean fulltext searches, AND instead of OR

Is there any way i can get results with AND instead of OR? Trying to search for "black cat" should only return records that contains both black and cat. I'm using the following code to get my result: SELECT * FROM `searchtbl` WHERE MATCH (text) AGAINST ('black cat' IN BOOLEAN MODE); sure there

Please help me: Boolean fulltext searches, AND instead of OR

Is there any way i can get results with AND instead of OR? Trying to search for "black cat" should only return records that contains both black and cat. I'm using the following code to get my result: SELECT * FROM `searchtbl` WHERE MATCH (text) AGAINST ('black cat' IN BOOLEAN MODE); sure there

Re: Fulltext searches

(specs,manufacturer) > > Chris > > Robb Kerr wrote: > >>Got a problem with my fulltext searches. Here is the structure of the table >>as displayed in MySQLyog... >> >>Column Information For - robeson_robesondb.robeson_inv >>---

Re: Fulltext searches

wrote: Got a problem with my fulltext searches. Here is the structure of the table as displayed in MySQLyog... Column Information For - robeson_robesondb.robeson_inv -- Field Type NullKey Default Extra Privi

Fulltext searches

Got a problem with my fulltext searches. Here is the structure of the table as displayed in MySQLyog... Column Information For - robeson_robesondb.robeson_inv -- Field Type NullKey Default Extra Privileges

Re: Fulltext searches question

At 13:00 -0500 7/19/03, Wesley Hobbie wrote: I am running MySQL 4.0.12 on Windows XP. I am trying to create a library database and have a table named "cardCatalog" in the "library" database. The cardCatalog has the following fields: callNumber (varchar(60)), title (varchar(255)), author (varchar(2

Fulltext searches question

I am running MySQL 4.0.12 on Windows XP. I am trying to create a library database and have a table named "cardCatalog" in the "library" database. The cardCatalog has the following fields: callNumber (varchar(60)), title (varchar(255)), author (varchar(255)), category (varchar(100)), location (varc

Re: Problem with FULLTEXT searches

Ok, I added IN BOOLEAN MODE and now it somewhat works...It is just a matter of optimizing it now. Thanks. - Original Message - From: "Cliff" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, June 27, 2003 8:13 AM Subject: Problem with FULLTEXT searches &g

Problem with FULLTEXT searches

I am trying to get the fulltext search working properly as described in the manual but some queries do not seem to be working correctly. When I run this query: SELECT allusa.name,title,full_text,match(title,full_text) against ('chicken soup lemon') from recipes, bb.allusa where innid = bb.allusa.i

Re: Slow FULLTEXT searches

On Thu, Feb 27, 2003 at 06:05:02PM +0100, Thomas Spahni wrote: > Jesse > > But then something else must be terribly wrong. As long as you are pulling > ten thousands of hits from the server, it may be slow. But when you reduce > the number of results with (let's say) 'LIMIT 100' I expect typical s

Re: Slow FULLTEXT searches

N MODE); > > > +--+ > > > | COUNT(*) | > > > +--+ > > > | 44 | > > > +--+ > > > 1 row in set (1.71 sec) > > to this: > > mysql> SELECT * FROM q WHERE MATCH(qt) > -> AGAINST ('+"fre

Re: Slow FULLTEXT searches

E); , it took 4.76 seconds--again, on a slower server, but this is returning only 44 results. It's certainly possible, and perhaps likely, that users will need to do fulltext searches on extremely common words--more common than "computer" in the abov

Re: Slow FULLTEXT searches

index in memory. Thomas Spahni (sql, query) On Thu, 27 Feb 2003, Jesse Sheidlower wrote: > I'm having a problem with FULLTEXT searches going much more slowly > than I expect, and need. It seems that this is perfectly straightforward > so I can't see why it's taking so long

Slow FULLTEXT searches

I'm having a problem with FULLTEXT searches going much more slowly than I expect, and need. It seems that this is perfectly straightforward so I can't see why it's taking so long; other people on this list have been reporting almost instantaneous results from FULLTEXT searches.

A way to get into the code to add functionality to FullText Searches

Hi Just I wondering the posibility of adding some functionality to MySQL MyISAM fulltext functionality, but I am quite confused. I read the ft_* files under $(MYSQL)/myisam, and there is nothing I can do. I'm wondering to add SGML support to FullText searches, so I need to exclude every

Re: mysql FULLTEXT Searches

Thanks for the input, unfortunately are production server is still v 3.26.xx Pat... - Original Message - From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Patrick Sherrill" <[EMAIL PROTECTED]>; "mySQL List" <[EMAIL PROTECTED]> Sent: Monday, J

Re: mysql FULLTEXT Searches

At 10:35 -0400 7/22/02, Patrick Sherrill wrote: >Are partial word searches available with a FULLTEXT index. > >I.E. could the following select statement return any results given that the >word "Pippins" or "Pippin's" is indexed ? > > >SELECT * from list WHERE MATCH (cols) AGAINST ('pipp') Not as

Re: mysql FULLTEXT Searches

ECTED]> To: "mySQL List" <[EMAIL PROTECTED]> Sent: Monday, July 22, 2002 10:35 AM Subject: mysql FULLTEXT Searches > Are partial word searches available with a FULLTEXT index. > > I.E. could the following select statement return any results given that the > word "P

mysql FULLTEXT Searches

Are partial word searches available with a FULLTEXT index. I.E. could the following select statement return any results given that the word "Pippins" or "Pippin's" is indexed ? SELECT * from list WHERE MATCH (cols) AGAINST ('pipp') TIA, Pat... [EMAIL PROTECTED] MySql --

Multiple FULLTEXT searches

sql,query Hi, how one can do a FULLTEXT search from multiple tables? SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database'); above format works for one table but how I need to alter it for it to search multiple tables? JAri Mäkelä ---

Re: Question about Fulltext searches/GWS_IDF

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

Question about Fulltext searches/GWS_IDF

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 w

Listing ignored words for fulltext searches

It would be nice if mysql had a function that would return a list of words that it's going to ignore when I do a full-text search. Its hard for me to explain to users of my site the difference between "your words didn't match anything", and "the database ignored your query because the words were

Re: FullText Searches

Hi! On Oct 02, Thomas Deliduka wrote: > For MySQL Full-text Searches and indexes. Do these indexes take up a lot of > disk space? > > Any information on this out there as to how much on average? In default configuration (that is without changing myisam/ftdefs.h) index can be as big as original

FullText Searches

For MySQL Full-text Searches and indexes. Do these indexes take up a lot of disk space? Any information on this out there as to how much on average? -- Thomas Deliduka IT Manager - New Eve Media The Solution To Your Internet Angst http://www.neweve.com/