Lorang Jacques wrote: >Hello, >This is the last time I will post this thread. Apparently nobody knows any >solution to this : > >The Fulltext search only matches those rows who match >teh exact word, so if I search for "bank", the query wont find banking. >(this would work with "like '%bank%'", but that is much slower). So is there >anything you can to make it also match those ?? > I don't think you can make FULLTEXT do substring matches. If LIKE is too slow, maybe try |INSTR|(str, substr) instead and see if it's any faster. > >Thankx >Lorang Jacques >sql is mysql > > >--------------------------------------------------------------------- >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 > > --------------------------------------------------------------------- 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
