> > EHS> I'm really looking forward to the 4.0.2 release. I hope > we will get some > EHS> more options to tweak and customize the fulltext search/indexing. > > There is a lot of bugs fixed in full-test search in 4.0.2: > http://www.mysql.com/doc/N/e/News-4.0.2.html >
Trying to install BitKeeper so I can try out the current 4.0.2 source tree. I have another 'test server' on which I try out new aplications/functions before installing/using them on the production server. > EHS> One other thing. I ran a Solid Database earlier, and > they had support for > EHS> indexed '%text%' search. Wildecard at start/end of > search string. Why > EHS> haven't MySQL support for this? Just wondering... > > MySQL doesn't use indexes in this case, because search word begins > with wildcard. MySQL will use indexes in the following statement: > SELECT * FROM table WHERE column LIKE "text%"; > > It will look for all words that >=text and <texu. for more details > how MySQL uses indexes look at: > http://www.mysql.com/doc/M/y/MySQL_indexes.html > I know MySQL does not support indexed search with '%string%', but I wondered why not? When we used a Solid Database and from what I remember from those days (was a long time ago :) we could run a search using wildcards at both ends of the string and it worked very fast. Only had around 200.000 book titles to search from then. Now 1.3mill. -I asked since I'm a little curious :) An indexed '%string%' would be very helpful. Regards Erlend Stromsvik --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
