SELECT A.*, @rank:=@rank+1 AS rank FROM
(SELECT id,CODE,title FROM knowledge)A, (SELECT @rank:=0) B ;
if(@usert=user_tmp.code,@rank:=@rank+1,@rank:=1) as rank,@usert=user_tmp.code from user_tmp,
(select @usert := null ,@rank:=0) b
rank
1
2,
3,
4