[GENERAL] LIMITS in SELECTs

[Fabrice Scemama]

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