update command to find and replace text - Mysql

Find and replace

Snippet Code


  
Rate this page :
  [ 0 votes]

Use "UPDATE" command to find and replace text in MYSQL.

Syntax: update table_name set field = replace(filed_name,'find string','replace with'); Example: update test set description = replace(description,'#','$');

Tags


Ask Questions

Ask Question