counting number of rows
Posted: Tue Jun 07, 2005 4:25 am
if on a table in mysql database contains these rows:
id | fname | lname
1 | Kenedy| John
2 | Tom | Brady
13 | Kim | Brady
20 | Marie | Presly
if fname = Tom is given,
Is there any function in mysql to allow us find number of records before the record containing Tom?
Thanks
id | fname | lname
1 | Kenedy| John
2 | Tom | Brady
13 | Kim | Brady
20 | Marie | Presly
if fname = Tom is given,
Is there any function in mysql to allow us find number of records before the record containing Tom?
Thanks