i want to know how can i use MySQL string functions on my DB.

I have MySQL db with following like data

```
+---+-----------------------+
|id | name                  |
+---+-----------------------+
| 1 | /sun/steave/xyz       |
| 2 | /mon/alan/asdsas      |
| 3 | /sun/mark/we          |
| 4 | /wed/john/rtd         |
| 5 | /thu/mich/dfgsd       |
+---+-------------------   -+

```

where name is of `type varchar(255)`.

i want to select only **name** i,e (/sun/**steave**/xyz).

i tried like

```
select substr(name,4) from my_table;

```

(i can't use length in `substring`, like `(name,4,6)` because name is dynamic)

which returns me 

```
steave/xyz 
alan/asdsas
mark/we
john/rtd
mich/dfgsd

```

How can i select only names from my table?
Is that possible through MySQL string functions?