LIMITS in SELECTs

Hi !

Is there a way to select only a range of rows from a table, using a command
like:

SELECT * FROM table WHERE where_statement LIMIT 50,100;

I've tried, and then read the doc, but found no information so far.

Thanks in advance.

Fabrice Scemama