codice:
select * from (
select @riga:=@riga+1 as riga,id,prova,elenco_campi from tabella,
(select @riga:=0) as r where ciao = 'prova' 
order by id limit 3) as t 
where riga in (1,3)