I use mySQL as a DBMS,
I have these rows in my table:

```
product_name | product_code | prod_type
prod1@00X    |  1           |    
@prod2@00X   |  2           | 
+prod3@@00X  |  3           | 

```

I wanna set the prod\_type = the product\_name without the special characters.

```
=> prod_type

   prod100X
   prod200X
   prod300X

```

(I can have other special characters not only '@' and '+')

How can I do that?