Tips & Tricks

How to Find & Replace in MySQL

Petar MitkovComment(0)

This tutorial will show you how to find and replace data in MySQL

 

 

 

Firstly you will need to login the mysql command line:

user@Box ~# mysql -u[username] -p[password] -h[hostname] database

Note: The hostname is not needed in the most cases. Also do not split -p and the password. If you do so it will ask you for the password one more time.

 

Now to find and replace the data in MySQL we need to execute the following command:

update [table_name] set [field_name] = replace([field_name],'[string_to_find]’,'[string_to_replace]’);

That’s it!
Good luck!

Petar Mitkov
https://osguides.net

Related Articles
Tips & Tricks

Linux Find Large Files

Petar Mitkov

There is no single command that can be used to list all large files. But, with the help of find command and shell pipes, you can easily list all large files. Linux List All Large Files To finds all files over 50,000KB (50MB+) in size and display their names, along with size, use following syntax: […]
Tips & Tricks

Change the spellchecker/dictionary in Firefox

Petar Mitkov

This will show you how to change the spellchecker/dictionary in your Firefox. Firstly we need to install the Spellchecker/Dictionary in Firefox: Go to the URL: https://addons.mozilla.org/en-US/firefox/search?q=&cat=3%2C0 Here you can find the dictionary in your language. Let’s say this is English. You should click on the English Dictionary and then the install button. Once it’s installed […]
Tips & Tricks

System information on Linux box

Petar Mitkov

This will show you how to check the system information on a linux box. Note: You will need to be logged as root. 1. Checking the CPU of the server: You will need to execute the command: cat /proc/cpuinfo Example: User@Linux ~# cat /proc/cpuinfo processor : 0 vendor_id : GenuineIntel cpu family : 15 model […]

Leave a Reply