Getting the count of same value in consecutive rows that are ordered by different field
I have a solution that does not need GROUP_CONCAT

PROPOSED SOLUTION

SET @x = 0;
SET @name = '';
SET @result = '';
SELECT name,consecutive FROM
(SELECT
    name,
    (@nametag:=MD5(CONCAT(name,':',result))),
    (@x:=IF(@name=@nametag,@x+1,1)) consecutive,
    (@name:=@nametag) inc
FROM finals ORDER BY name,id) A
WHERE consecutive &gt;= 3;


PROPOSED SOLUTION EXECUTED

mysql&gt; SELECT name,consecutive FROM
    -&gt; (SELECT
    -&gt;     name,
    -&gt;     (@nametag:=MD5(CONCAT(name,':',result))),
    -&gt;     (@x:=IF(@name=@nametag,@x+1,1)) consecutive,
    -&gt;     (@name:=@nametag) inc
    -&gt; FROM finals ORDER BY name,id) A
    -&gt; WHERE consecutive &gt;= 3;
+------+-------------+
| name | consecutive |
+------+-------------+
| Kyle |           3 |
+------+-------------+
1 row in set (0.02 sec)

mysql&gt;


SUBQUERY'S OUTPUT

mysql&gt; SELECT
    -&gt;     name,
    -&gt;     (@nametag:=MD5(CONCAT(name,':',result))),
    -&gt;     (@x:=IF(@name=@nametag,@x+1,1)) consecutive,
    -&gt;     (@name:=@nametag) inc
    -&gt; FROM finals ORDER BY name,id;
+------+------------------------------------------+-------------+----------------------------------+
| name | (@nametag:=MD5(CONCAT(name,':',result))) | consecutive | inc                              |
+------+------------------------------------------+-------------+----------------------------------+
| John | 84cc30b986fe149dfb765dd09fad8a60         |           1 | 84cc30b986fe149dfb765dd09fad8a60 |
| John | 534b3d163a04b74a72c6dbe68db1c01e         |           1 | 534b3d163a04b74a72c6dbe68db1c01e |
| John | 84cc30b986fe149dfb765dd09fad8a60         |           1 | 84cc30b986fe149dfb765dd09fad8a60 |
| John | 84cc30b986fe149dfb765dd09fad8a60         |           2 | 84cc30b986fe149dfb765dd09fad8a60 |
| Kyle | 30fac0873cf25ad17b38bc37bda4b850         |           1 | 30fac0873cf25ad17b38bc37bda4b850 |
| Kyle | 30fac0873cf25ad17b38bc37bda4b850         |           2 | 30fac0873cf25ad17b38bc37bda4b850 |
| Kyle | 30fac0873cf25ad17b38bc37bda4b850         |           3 | 30fac0873cf25ad17b38bc37bda4b850 |
| Kyle | 4a4e0aaa102c37f098bd6afd13ccfea0         |           1 | 4a4e0aaa102c37f098bd6afd13ccfea0 |
+------+------------------------------------------+-------------+----------------------------------+
8 rows in set (0.00 sec)

mysql&gt;


GIVE IT A TRY !!!

I just answered a similar question 2 days ago (Logic Value of Assignment Expression)