RE: MySQL 4.0 - Order By & Limit

2001-10-18 Thread Steve Meyers
: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 k

RE: MySQL 4.0 - Order By & Limit

2001-10-18 Thread Ashwin Kutty
lts 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 > > >

RE: MySQL 4.0 - Order By & Limit

2001-10-18 Thread Steve Meyers
y [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

Re: MySQL 4.0 - Order By & Limit

2001-10-18 Thread Ashwin Kutty
er 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