Have a look in the manual, it says LIMIT [offset], rows, so you should say:
order by id limit 1932, 10;
SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [HIGH_PRIORITY]
[DISTINCT | DISTINCTROW | ALL] select_expression,...
[INTO OUTFILE 'file_name' export_options] [FROM table_references
[WHERE where_definition] [GROUP BY col_name,...]
[HAVING where_definition]
[ORDER BY {unsigned_integer | col_name | formula} [ASC | DESC] ,...]
[LIMIT [offset,] rows]
Tobias.
-----Ursprüngliche Nachricht-----
Von: Ron Beck [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 16. Februar 2001 17:23
An: [EMAIL PROTECTED]
Betreff: Display information
Hello all,
I have a database with a little over 2000 records. I want to be able to
construct a query that says something like this...
select id,lot_id,lot_type from scrap_table
<starting with record 1932> (part I need help with)
order by id limit 10;
which should give me records 1932 - 1942 like this...
+------+----------+----------+
| id | lot_id | lot_type |
+------+----------+----------+
| 1942 | 0034906 | F |
| 1941 | 0100308 | F |
| 1940 | 0036309 | S |
| 1939 | 0033503 | F |
| 1938 | 0034108E | D |
| 1937 | 0034712 | F |
| 1936 | 0029404 | F |
| 1935 | 0032706 | F |
| 1934 | 0029404 | F |
| 1933 | 0100307 | F |
| 1932 | 0100404 | F |
+------+----------+----------+
any suggestions?
Ron
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
