Consulta_beco

table:
select * from users;

+---------+----------------------+-------------------+--------+
| user_id | name                 | email             | active |
+---------+----------------------+-------------------+--------+
|       1 | Ricardo              | ricardo@hola.com  |      1 |
|       4 | Sofia                | sofia@hola.com    |      1 |
|       5 | juan                 | fernanda@hola.com |      1 |
|       6 | Jose Guillermo       | memo@hola.com     |      1 |
|       7 | Maria                | maria@hola.com    |      1 |
|       8 | Susana               | susana@hola.com   |      1 |
|       9 | Jorge                | jorge@hola.com    |      1 |
|      10 | hola - nuevo - nuevo | sofia@gmail.com   |      0 |
|      17 | juan                 | juan@hotmail.com  |      1 |
|      19 | pepe                 | laura@hola.com    |      4 |
|      20 | pepe                 | jose@hola.com     |      4 |
+---------+----------------------+-------------------+--------+

insert into users(name,email) values ('Enrique','ricardo@hola.com') on
duplicate key update active=2, name=concat(name,'-nuevo');

2 rows affected
select * from users;
+---------+----------------------+-------------------+--------+
| user_id | name                 | email             | active |
+---------+----------------------+-------------------+--------+
|       1 | Ricardo-nuevo        | ricardo@hola.com  |      2 |
|       4 | Sofia                | sofia@hola.com    |      1 |
|       5 | juan                 | fernanda@hola.com |      1 |
|       6 | Jose Guillermo       | memo@hola.com     |      1 |
|       7 | Maria                | maria@hola.com    |      1 |
|       8 | Susana               | susana@hola.com   |      1 |
|       9 | Jorge                | jorge@hola.com    |      1 |
|      10 | hola - nuevo - nuevo | sofia@gmail.com   |      0 |
|      17 | juan                 | juan@hotmail.com  |      1 |
|      19 | pepe                 | laura@hola.com    |      4 |
|      20 | pepe                 | jose@hola.com     |      4 |
+---------+----------------------+-------------------+--------+