I am trying to split a column into two and compare to find duplicate values in my column.

The following is an example of data in my column

```
'ETORHHF000224000023305'
'ETORHHF000002000000623'
'ETORHHF000002000000624'
'ETORHHF000002000000625'
'ETORHHF000002000000626'
'ETORHHF000002000000627'
'ETH0001845254525 '
'ETH0001845264526 '
'ETH0001845274527 '
'ETH0001845284528 '
'ETH0001845304530 '

```

The query to get all this id in my database is 

```
select * from animals

```

I have found the following solution online but it is for *Microsoft SQL Server* and I am not able to make it work for *MySQL*

```
SELECT m.name,
       LEFT(m.name, CHARINDEX("\", m.name) - 1) AS column1,
       RIGHT(m.name, LEN(m.name) - CHARINDEX("\", m.name)) AS column2
FROM MyTable m

```