MySQL Forums
Forum List  »  Newbie

Row select in old mysql versions
Posted by: Michael Arnold
Date: June 29, 2005 10:14AM

We are using MySQL version 4.0.20-standard.

Our application requires a query to do a row select. From what I have found this version does not support rownum. We are unable to update the version of MySQL. Can anyone give us some support.

e.g.

Select * from table where rownum=1242;

Any help would be greatly appreciated.

Options: ReplyQuote


Subject
Written By
Posted
Row select in old mysql versions
June 29, 2005 10:14AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.