i have this table

```
mysql> select name from test;
+---------+
| name    |
+---------+
| foo     |
| bar     |
| foobar  |
| anton   |
| budi    |
| anton S |
+---------+
6 rows in set (0.00 sec)

```

how to know if first 'anton' is record number 4?

is there any faster query than this...

```
select rank from (select @rownum:=@rownum+1 rank,p.name from test p, (SELECT @rownum:=0) r) a, (select * from test where name like 'anton%' limit 1) b where b.NAME = a.name

```