Split value field

Databases
1

Hi all.

I need your help.

In the field “mem” (varchar 255) of MySql table_name, I have this value:

.Mem C..For A..Gia A..Cir G.

I need this output:

.Mem C
For A
Gia A
Cir G.

And try this query:

SELECT split(mem, "..")
FROM table_name

But I receive this error:
FUNCTION dbase.split does not exist

Can you help me?

2 
SET @str='.Mem C..For A..Gia A..Cir G.';

SELECT SUBSTRING_INDEX(@str,'..', 1)
UNION ALL
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(@str,'..', 2),'..', -1)
UNION ALL
SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(@str,'..', 3),'..', -1)
UNION ALL
SELECT SUBSTRING_INDEX(@str,'..', -1)
3

Thanks.