Skip to content

NerdifyMyLife

Upping my Nerd cred

  • Home
  • Contact

Category: MySQL stuff

Easy Stuff, Misc, MySQL stuff

Search and replace for MySQL

I often have to search and replace through lots rows in MySQL, so this is useful: update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, 'find this string', 'replace found string with this string'); A good example of this is replacing URL strings in CMS databases. I'll show a simple Magento one. Magento stores all the URLs in … Continue reading Search and replace for MySQL

June 3, 2013Leave a comment

Category Cloud

Android Apps Blender BrainTickets Case Studies Consumer Electronics Easy Stuff Future Friday Goals HelloAroundTheWorld iPhone Apps M2SS Magento Magento2 Magento Monday Misc MySQL stuff New Hotness Old School On the Reg procrastination Q4 Round Off Tougher Stuff Uncategorized Unreal Engine 4
Powered by WordPress.com.