display mysql rowcount increase numbering

shell script
mysql -uusername -ppassword dbname -e "select @row:=@row+1 'nocount', p.fieldname from tablename p,(select @row:=0) r where fieldname = 'searchstring'"

 

mysql query
select @row:=@row+1 'nocount', p.fieldname from tablename p,(select @row:=0) r where fieldname = 'searchstring'";

 

result:

nocount | fieldname

1 | value

2 | value

3 | value

4 | value

5 | value

6 | value

7 | value

8 | value

.

.

.