A certain row in a table?

[cturner01]

Can someone please tell me how I can display only a certain row in a table not the first row? Thanks in advance.

[clamcrusher]

http://sqlcourse.com/

[cranial-bore]

Which certain row? My favourite row? If so that's the 11th row.

SELECT * FROM `table` LIMIT 10, 1