獲取某個資料所在資料列表中的行數 mysql

select * from (
select
@rownum := @rownum+1 as rownum,
goods_id
from table_goods, (select @rownum:=0) t where test_id = 10) m
where m.goods_id = 57806