Mysql Replace Function Usage


If you want to change some string content of a column, you can use REPLACE function as follow:

SET url = REPLACE(url, '', '')

urls: Table Name
url: Column Name

REPLACE function first parameter is column name, second parameter string value to be changed, and third parameter is new string value.

© 2019 All rights reserved. Codesenior.COM