1030: Got error 127 from table handler

2001-09-06 Thread Lorang Jacques
ne of those tables everything works fine. Anyone an idea ? Lorang Jacques - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this t

Convert to MyISAM

2001-09-06 Thread Lorang Jacques
nvert ? Thankx for reply, Lorang Jacques - 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 PROTEC

Re: 1030: Got error 127 from table handler

2001-09-06 Thread Lorang Jacques
Solved the prob, thankx Lorang Jacques - Original Message - From: "Chris Bolt" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, September 06, 2001 11:56 AM Subject: RE: 1030: Got error 127 from table handler > > Thankx for reply. > > But i

Mysql Fulltextsearch

2001-09-07 Thread Lorang Jacques
TEXTSEARCH on my tables. As it is quiet some work, I first want to ask you guys if this is really going to make my queries faster (much faster ?) Or perhaps you know any better solution ? Lorang Jacques - Before posting, pleas

Limit query to a value

2001-09-07 Thread Lorang Jacques
r by tot desc 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]

Fulltext search

2001-09-07 Thread Lorang Jacques
One last question : 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

Fulltext search

2001-09-07 Thread Lorang Jacques
One last question : 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

Fulltext search (Advanced)

2001-09-08 Thread Lorang Jacques
with "like '%bank%'", but that is much slower). So is there anything you can to make it also match those ?? Lorang Jacques - Before posting, please check: http://www.mysql.com/manual.php (the man

Fulltext search

2001-09-10 Thread Lorang Jacques
, but that is much slower). So is there anything you can to make it also match those ?? Thankx Lorang Jacques sql is mysql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.co

Exact match ?

2001-09-21 Thread Lorang Jacques
Hello I was wondering if it is possible (in a search result) to first get those results where the search string matches exactly (whole word) and then those who include the search string. Example : Searchstring : car Exact match : car then Including the serachstring : incarnation Lorang

Exact match ?

2001-09-21 Thread Lorang Jacques
Hello I was wondering if it is possible (in a search result) to first get those results where the search string matches exactly (whole word) and then those who include the search string. Example : Searchstring : car Exact match : car then Including the serachstring : incarnation Lorang