A few days ago I solved a problemon to list a query result but stop the counter and start it again in the same query ...
Count or Account in a SELECT MySQL
in fact I wanted to reach this result (stopping at 4)
and there we restart ...
That topic .. SOLVED! now I really wanted to record in another temporary column an identifier of each sequence or enumeration ...
and there we restart ... and the second cycle begins
and so on ... can it be? I hope you can help me as they did before ..
In the previous answer, Patricio made you make a Cartesian product between 2 tables, one with your data, and another with a column in 0, so that you could go iterating over it and go counting results.
If we steal your idea, we can add another column ... and restart it only when the first pass 4 ... something like this:
SELECT apellido,
nombre,
CAST(@s:= (CASE WHEN @s = 4 THEN 1 ELSE @s+1 END) AS UNSIGNED) AS '#',
CAST(@t:= (CASE WHEN @s = 4 THEN @t+1 ELSE @t END) AS UNSIGNED) AS 't#'
FROM mitabla,
(SELECT @s:= 0) AS s,
(SELECT @t:= 0) AS t
WHERE ciudad = "NEUQUEN"
ORDER BY apellido asc, nombre asc
If the idea is correct, this would sum to t, every time s reaches 4 ...