模糊查询 , 获取行号

// 模糊查询 (小数点后第四位零)

SELECT * FROM doubles WHERE (

`value` LIKE '%.___0%'

) LIMIT 0,50

// 获取行号

set @rn=0;

SELECT (@rn := @rn+1) as `rn`,video_task.* FROM `video_task` ORDER BY version ;

UPDATE video_task SET version = RAND() * 100;