mySQL can use variables in a select statement - so to do the equivalent of MSSQL Row_Number() you can use

select @var = 0
select @var := @var + 1 as rownumber, columns from tblSites which will return a row number for each row - this could be usefull if you want to store the results in an array for example.