mysql - Select a specific number of records from a record -
i have query working need show 4 record record 5 of database? how query look? select noticias.id, idn, titulo, chamada, foto_a, subcatid, noticias_subcategorias.subcategoria, slug, noticias.rlogdata noticias, noticias_subcategorias noticias.subcatid = noticias_subcategorias.id , noticias.status = 1 , posicao = 1 , noticias.tipo = 2 order idn desc limit 0, 4 thanks. if want start @ record 5, you'd use limit 4 offset 4 skip first 4 records.