SELECT next higest number from a column

[suttercain]

Hi everyone.

 

I have a table which has, for simplistic reasons, 5 rows of numbers. The numbers are as follows: 1, 2, 3, 7, 8. Let's say I'm at the row with the number 3, how would I tell it to select the next number, in this case 7?

 

I know how to do it in increments of one, but how can I do it, if the numbers are not consistent with the increment of one?

 

Thanks.

[ted_chou12]

SELECT field1

FROM tablename

WHERE id = ($currentId + 1)