Skip to content

ez linux admin

making Linux a little easier

  • linux-basics/
  • cheat-sheets/
  • tech-terms/
  • about-us/
  • hacked?/

Tag: find and replace mysql

Find and replace mysql

update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’); Make sure and remove the [] tab when entering the variable. If you know how to do this database wide without needing the table listed please post in the comments.

Published
Categorized as Linux Commands, Linux Tricks Tagged find and replace mysql, mysql, phpmyadmin

Categories

Archives

Grab hosting for only $2.99/mo

web host

Partners

  • Centos
  • Linux
  • Redhat
  • SSLCA
  • Web Host Pro

Quality Websites

  • EZ Domain Name
  • Free Image Hosting
  • Internet Marketing
  • Web Host Pro
ez linux admin
Proudly powered by WordPress.