Could you also give a sample of the results you're getting that are incorrect? You don't have to give every field, just the title should do. Steve Meyers
> -----Original Message----- > From: Ashwin Kutty [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 18, 2001 11:31 AM > Cc: [EMAIL PROTECTED] > Subject: RE: MySQL 4.0 - Order By & Limit > > > > Point well taken.. The query is as follows:- > > SELECT * FROM dddeli WHERE title LIKE "%$keyword%" ORDER BY title > desc LIMIT $start,$end; > > Where $keyword is the keyword to search by from the field title, $start > and $end are to dictate which page of the results, etc.. > > title is varchar(128) > > and dddeli has 33 fields.. > > On Thu, 18 Oct 2001, Steve Meyers wrote: > > > It would help if you posted the actual query and results you > are getting, instead of showing "simulated" results. You mention > the query below in your first post, but you never give the actual > results of it. > > > > Steve Meyers > > > > > > > -----Original Message----- > > > From: Ashwin Kutty [mailto:[EMAIL PROTECTED]] > > > Sent: Thursday, October 18, 2001 5:58 AM > > > To: [EMAIL PROTECTED] > > > Subject: Re: MySQL 4.0 - Order By & Limit > > > > > > > > > > > > I just saw the mistake I made in my original post.. I want to Order By > > > letter, but when I do that with the Limit clause the results are as > > > shown in the original post.. Anyone know what the problem could be? > > > > > > > > > Steve Meyers wrote: > > > > > > >That is actually how it is supposed to work -- MySQL gets all > > > the rows, sorts them, and then returns up to the limit. What you > > > suggest would make no sense in any application, as far as I can > > > tell. The problem with the SQL queries given in the original > > > post is the the ordering is being done by #, not letter. Of > > > course it will be fairly haphazard. If you want to sort by > > > number, then letter, you will need to specify it in your query as > > > such (ORDER BY #, letter). > > > > > > > >Steve Meyers > > > > > > > > > > > >>-----Original Message----- > > > >>From: Fournier Jocelyn [Presence-PC] [mailto:[EMAIL PROTECTED]] > > > >>Sent: Tuesday, October 16, 2001 1:31 PM > > > >>To: [EMAIL PROTECTED] > > > >>Cc: [EMAIL PROTECTED] > > > >>Subject: Re: MySQL 4.0 - Order By & Limit > > > >> > > > >> > > > >>Hi, > > > >> > > > >>I don't see the interest of this kind of behaviour : the > main benefit of > > > >>LIMIT is MySQL stops fetching rows as soon as the number of > > > rows specified > > > >>in LIMIT is achieved. > > > >>The behaviour you describe requires that MySQL fetches all the > > > rows, sorts > > > >>it, and then applies LIMIT. (so no speed optimization !). > > > >>For your example, just use the SQL query without LIMIT, and > > > then get only > > > >>the rows that interest you :) (I assume you are using > language like PHP, > > > >>C++, etc... to execute this query ?) > > > >> > > > >>Regards, > > > >> > > > >>Jocelyn Fournier > > > >>Presence-PC > > > >> > > > >>----- Original Message ----- > > > >>From: "Ashwin Kutty" <[EMAIL PROTECTED]> > > > >>Cc: <[EMAIL PROTECTED]> > > > >>Sent: Tuesday, October 16, 2001 8:48 PM > > > >>Subject: MySQL 4.0 - Order By & Limit > > > >> > > > >> > > > >>>Hi, > > > >>> > > > >>>I thought version 4.0 was supposed to do a Order By first > and then a > > > >>>Limit after that on the results returned on a SELECT.. I have just > > > >>>installed the new version and I hit the same problem I was hitting > > > >>>before, i.e., the Limit seems to be executing first and > then the Order > > > >>>By causing all the results to be haphazard when they > display.. Now if I > > > >>>go for a wider set of results, i.e. increase the Limit, the > > > results come > > > >>>a lot better then, i.e. more of them are ordered right, but > > > then, again, > > > >>>it still skips a lot more.. As an example:- > > > >>> > > > >>>Results Set > > > >>># letter > > > >>>1 f > > > >>>1 a > > > >>>2 b > > > >>>1 c > > > >>>3 d > > > >>>1 e > > > >>>1 h > > > >>>1 g > > > >>> > > > >>> > > > >>>Limit 2 > > > >>> > > > >>>Order By # > > > >>> > > > >>>1 a > > > >>>1 f > > > >>> > > > >>>Then when I go to the next set, I get > > > >>> > > > >>>1 c > > > >>>1 e > > > >>> > > > >>>Instead I would like it to be as the following:- > > > >>>First Set:- > > > >>>1 a > > > >>>1 c > > > >>>Second Set:- > > > >>>1 e > > > >>>1 f > > > >>> > > > >>>etc.. > > > >>> > > > >>>Any ideas? > > > >>> > > > >>>These are a few specs of the server & stuff.. > > > >>>Linux kernel 2.4.7-2 on a Redhat 8 server running Mysql 4.0.0-alpha > > > >>>The query I have is as follows:- > > > >>>SELECT * from tablename WHERE fieldname LIKE "%keyword%" ORDER BY > > > >>>fieldname DESC LIMIT 0,10; > > > >>> > > > >>>Thanks.. > > > >>> > > > >>> > > > > >>>--------------------------------------------------------------------- > > > >>>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 > > > >> > > > >> > > > > > > > > > > > > > > > > > > > > > > > > > --------------------------------------------------------------------- > > 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 > > > > > > --- > Ashwin > kutty.. > Systems Administrator > Dalhousie University Libraries > (902) 494-2694 > > > --------------------------------------------------------------------- > 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