Re: fulltext indices

2004-03-25 Thread Brent Baisley
First, full text indices have nothing to do with importing the data, it's just a special type of indexing for searching. The reason you got several rows is that you probably did not specify delimiters. Thus, every time a return was encountered, a new record was created because return is the def

Re: fulltext indices

2004-03-25 Thread Kurt Haegeman
Brandon Carter wrote: Is it possible to fit an entire article (say, a newspaper article) into one cell of a MySQL database? When I tried load data local infile the file was imported into several rows! Perhaps I just don't understand the use of a fulltext index. --bhcesl Do you Yahoo!? Yahoo! F

fulltext indices

2004-03-25 Thread Brandon Carter
Is it possible to fit an entire article (say, a newspaper article) into one cell of a MySQL database? When I tried load data local infile the file was imported into several rows! Perhaps I just don't understand the use of a fulltext index. --bhcesl Do you Yahoo!? Yahoo! Finance Tax Center -

Re: Affecting weighting of fulltext indices

2002-07-03 Thread Scott Gifford
times when creating the index. For example: create fulltext index test on TxKeywords (Title,Title,Description); seems to have roughly the desired effect, but I don't exactly understand what it's doing, and I don't know if this is supported behavior, or if might go