sql - MySQL update statement that partially changes the value of a column -
i need update value of column in db table substituting part of path.
my current path is:
software-features/adadadad.html
it should become:
software/adadadad.html
i need sql update statement (valid mysql 5.5) changes part of value of column
is want?
update t set path = replace(path, 'software-features', 'software') path 'software-features%';
Comments
Post a Comment