1.declare t_hasSigned tinyint(3); set t_hasSigned = 0; set @sqlStr = concat('select count(playerId) from tb_sign where playerId =',iPlayerId , ' and day', iSignDate, '=1 into @t_hasSigned' );

SELECT * FROM table_name ORDER BY rand() LIMIT 5;