How to find and replace in mysql records

[ahmedeqbal]

Hello Friends,
I've around 1000 records in mysql database. in content table im using image source url like 'img.mydomain.com' so today I've registered new domain. so i want to find replace following domain and update my new domain in image path url. so please let me know how to find/replace???

thanks waiting for reply..

[szabizs]

You can update all directly from MySQL

mysql -> UPDATE yourTable SET ON yourField='newLink' WHERE yourField='oldLink'

[richieking]

szabizs Just gave you the sutff.

However if you really want to search and replace. Please advice and i will script something for you.
;)