I have a mysql table (in AWS RDS) with field F1, F2 and F3. F1 has strings like 'abc-def'. What I need to do is split the F1 values by hyphen into two strings ('abc' and 'def') and store them into F2 and F3 in the same row.

the record before changing:

```
F1: abc-def 
F2:
F3:

```

the record after changing:

```
F1: abc-def
F2: abc
F3: def

```

It seems that mysql does support regexp but not back reference. My last resort would be using mysqldump but I want to see if there is any way to do this in mysql directly. 

Any reply is appreciated!