MYSQL LIMIT. Is it possible to skip certain rows?

Add order by comtitlesub. Idcts at the end of you query, but before the limit clause comtitlesub. Idcts = %s ORDER BY comtitlesub.

Idcts LIMIT 1,6 basically, changing the id doesn't reorder them, rows are stored in order they have been created, and retrieved that way by default.

Add "order by comtitlesub. Idcts" at the end of you query, but before the limit clause. ... comtitlesub.

Idcts = %s ORDER BY comtitlesub. Idcts LIMIT 1,6 basically, changing the id doesn't reorder them, rows are stored in order they have been created, and retrieved that way by default.

This is giving me the same results. But I hadn't considered using Order By for some reason so I'm going to experiment. Oh and thanks for explaining why changing the IDs didn't work :) – Andrew Sep 20 at 13:25 This fixed it for me when I used ORDER BY areas.Id (The query utilised two tables).

I got so hung up on trying to stretch LIMIT to do something it isn't intended to do that I didn't even consider doing it this way. Thanks – Andrew Sep 20 at 13:31 as @Michael said, doing somehting like where id in (2, 3, 4, 5, 6) or where id betweeen (2 and 6) (now that IDs have been redone) would really make us all sleep better ;) – roselan Sep 20 at 13:33.

Andrew, LIMIT will delimit according to a specific order, in your case, coincidentally the default order was the same than ID order, now that you've changed it, you will need to order by ID: ORDER BY comtitlesub.idcts.

Thanks for the answer. Can't believe I didn't even think to use Order By! – Andrew Sep 20 at 13:48.

I believe the easiest course would be to modify your WHERE clause to exclude the rows you want excluded. For example: WHERE comtitlesub. Idcts = %s AND someothercol NOT IN ('cat','frog','kazoo') Ideally for maintainability, you would want someothercol to hold stable data rather than a numeric ID which might change as your application data changes.

Many thanks for your time. The ORDER BY example gave me the 'quick fix' I needed. – Andrew Sep 20 at 13:47.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.