mysql control center-prolly stupid question:)

[lagmann]

Originally Posted by Marratook

i have my query set to 1000, and it only show 1000 querys, but its always the first 1000 posts, ie items has about 26000 post if i want it to show that last 1000 post as 25000-26000 can i edit that somewhere?

Here the query to return the last 1000 item :

Select * from items order by ID desc limit 1000;

Originally Posted by Marratook

Also if i want it to show post/ids 2455-3455 is there anyway to do this?

Select * from items where (id between 2455 and 3455);

hope that help