Selecting a starting row

I have a table and I want to start the select with the 20th row. How do I do this?

Does conditionals work on "limit"

Light Poster

27 posts since Aug 2009

Reputation Points: 10

Solved Threads: 2

following query will show 100 records and start from record no 20

select * from table1 a where mycol='mycondition' limit 20, 100

Nearly a Posting Virtuoso

1,306 posts since Dec 2008

Reputation Points: 257

Solved Threads: 270

Thanks

Light Poster

27 posts since Aug 2009

Reputation Points: 10

Solved Threads: 2

This question has already been solved

You