CODEWITHSUNDEEP
mysqlsql
Ed Dias
Ed Dias

Reputation: 185

Select a specific number of records from a record

I have this Query that is working normally but now I need to show only 4 record from record 5 of the database?

How would this query look?

Select   noticias.id,
         idn,
         titulo,
         chamada,
         foto_a,
         subcatid,
         noticias_subcategorias.subcategoria,
         slug,
         noticias.rlogdata
From     noticias,
         noticias_subcategorias
Where    noticias.subcatid = noticias_subcategorias.id
         And noticias.status = 1
         And posicao = 1
         And noticias.tipo = 2
Order By idn Desc
Limit 0, 4

Thanks.

Upvotes: 0

Views: 165

Answers (1)

user1837296
user1837296

Reputation: 596

If you want to start at record 5, you'd use LIMIT 4 OFFSET 4 to skip the first 4 records.

Upvotes: 1

Related Questions