Home » MySQL Replace

MySQL Replace

Published June 9, 2015 by Praveen Anaparthi

Last updated on June 20, 2015

Replace() is one of the MySQL string function, It will search with the given string and REPLACE or UPDATE in all occurrences with given string.

  REPLACE(str,from_str,to_str)

mysql> SELECT REPLACE('www.arjunphp.com', 'w', 'Ww');
        -> 'WwWwWw.arjunph.com'

That’s it.

Published in PHP / MySQL

0 0 votes

Article Rating