MySQL - Does not support LIMIT in IN/ALL/ANY/SOME subquery: Error Code 1235

           UPDATE aboutme.RandomSample SET TestFlag = 1 WHERE UGCID in  
           (SELECT UGCID FROM   
                (SELECT UGCID FROM aboutme.RandomSample WHERE TwitterURI = @twitter_uri ORDER BY RAND() LIMIT 10) tmp  
           );