Member Avatar for 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..

  • 3 Contributors
  • 2 Replies
  • 87 Views
  • 16 Hours Discussion Span
  • Latest Post Latest Post by richieking
Member Avatar for Szabi Zsoldos

You can update all directly from MySQL

mysql -> UPDATE yourTable SET ON yourField='newLink' WHERE yourField='oldLink'
Edited by Szabi Zsoldos because: n/a
Member Avatar for 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.
;)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.