..
The REPLACE function in MySQL performs the replacement of a string, the string may be found in the main, with another. Here's an example:
SELECT REPLACE ('mrwebmaster', 'r', 'x');
return:
mxwebmastex
As we see in our example, thanks to the REPLACE function, we replaced all occurrences of the letter "r" with la lettre "X" in the string "mrwebmaster".
| |
MS Access (Advanced)
Learn how to create and manage databases quickly and easily. Starting from 29 €. |
| |
MySQL (Course)
Management of open-source database. From 39 €. |
| |
SQL and Database (Course)
Create and manage relational databases. From 39 €. |