Thank you so much The_Doc_Man, it works very well. But now i have another question.
If i have the next table:
ID | PRODUCT NAME |
1 | Windows Professional 2016 - us.es |
2 | Windows Office Professional 2019 |
3 | Windows Profesional 2019 |
4 | Windows Professional 2016 - en.proof |
Now i want to remove the same as before, but i have to remove the word "Office" of the second product, and add the letter "s" in the third product. And the same as before, in just one query how can i do it? Is because
I need to count each of the products and it's necessary to be named equal.
Thank you so much.