MySql PartionBy

SELECT tableOld.*,
if(@channelName = tableOld.channelName,
@rank := @rank + 1,
@rank := 1)
AS rank,
@channelName := tableOld.channelName
FROM (SELECT *
FROM OpearateTableResultDockerForPage
ORDER BY channelName, date ASC) tableOld,
(SELECT @channelName := NULL, @rank := 0) a;