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