Skip to content

Instantly share code, notes, and snippets.

@betweenbrain

betweenbrain/gist:6370134

Created August 28, 2013 19:23
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save betweenbrain/6370134 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save betweenbrain/6370134 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Find and Replace - CLI
Raw
gistfile1.sql
update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');
update jos_content set `fulltext` = replace(`fulltext`,'foo','bar')
See: http://stackoverflow.com/questions/7615659/sql-fulltext-returning-null
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment