Exact match ?
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 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
Exact match ?
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 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
Fulltext search
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 ?? 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
Fulltext search (Advanced)
Hey there, no one knows this. Are there also Mysql developpers in this community. If so, I think this is one for them : 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 those ?? 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Mysql Fulltextsearch
Hello, Actually I am programming an web directory (like yahoo). But my sql queries need ernormous cpu resources. So it is quiet slow. I can't use indexing because my serach works with LIKE '%$serchstring%'. (apparently then it dosen't help). Now I was wondering if it would get faster by using FULLTEXTSEARCH 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, 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
Limit query to a value
Hello, How can I limit the query to those rows where SUM(value) as Tot 0. If I put it in an where clause it get an error. So how to do that SELECT id,url,title,description,top,keyword,SUM(value) as Tot FROM links LEFT JOIN keywords on links.id=keywords.LinkId Group by id order 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] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fulltext search
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 those ?? 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Fulltext search
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 those ?? 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
1030: Got error 127 from table handler
Hello, I was working with Mysql an nerver had any problem, the suddenly from one moment to the other, some tables didn't work correctly any more. Any select command on them returns me : 1030: Got error 127 from table handler. But if I do a select command on a other table with a join on one 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 thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Convert to MyISAM
Hello, I would be pleased if anyone could tell me hoe to convert my tables to MyISAM. I used to run an old MYsql version, but now got the newest one, but still my tables can't use the features of the new version and i guss it is because of the table type not being MyISAm. So how to convert ? 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: 1030: Got error 127 from table handler
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 if I use Table Repair it says : The handler for te table doesn't support Check/Repair. What does SHOW TABLE STATUS LIKE 'tablename'; say for the Type column? - 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