#1 Problems Converting ROW()m ROW_NUMBER() OVER to MySql

[Jeffrey Allen]

The command line utility doesn't seem to be correctly converting ROW(), ROW_NUMBER(), and ROW_NUMBER() OVER() queries correctly. See sample below:

SELECT Id, Email, EmailType, ContactPersonId, ConcurrencyId
FROM(
SELECT ROW_NUMBER() OVER(ORDER BY Id) AS Row, Id, Email, EmailType, ContactPersonId, ConcurrencyId
FROM EmailAddress) AS EmailRows
WHERE(( Row between( startRowIndex) AND startRowIndex
+ maximumRows- 1) OR startRowIndex=- 1 OR maximumRows=-
1) AND ContactPersonId= cPersonId;

I have tried tof ind documentation on the MySql equivalents for ROW(), ROW_NUMBER(), and ROW_NUMBER() OVER() queries and have not had any luck finding and documentation on any MySql equivalent functions.