Skip to content

Instantly share code, notes, and snippets.

@D4R4

D4R4/mysql_replace-text.sql

Created April 1, 2019 07:49
Show Gist options
  • Save D4R4/2b06a72ea4570e41266c7c5ebf6ef84f to your computer and use it in GitHub Desktop.
Save D4R4/2b06a72ea4570e41266c7c5ebf6ef84f to your computer and use it in GitHub Desktop.
Download ZIP
replace text in mysql text field
Raw
mysql_replace-text.sql
UPDATE
table_name
SET
column_name = REPLACE(column_name, 'text to find', 'text to replace with')
WHERE
column_name LIKE '%text to find%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment