..


Sponsored Links

REPLACE

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".

In the same category ...
E-Learning
MS Access (Advanced) MS Access (Advanced)
Learn how to create and manage databases quickly and easily. Starting from 29 €.
MySQL (Course) MySQL (Course)
Management of open-source database. From 39 €.
SQL and Database (Course) SQL and Database (Course)
Create and manage relational databases. From 39 €.
Sponsored Links