set @row_number = 0; SELECT(@row_number:=@row_number+1) as row_number,title FROM `codes`;