How to Find & Replace Data in MySQL



To find a string in a certain field and replace it with another string:

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

Comments

Post a Comment

Popular posts from this blog

Some mistakes to avoid while looking for a job

Communicate well, don't fabricate information on resume during an interview.  Whether you are a fresher or a seasoned professional, there's always room for improvement, especially during an interview. Because of the mistakes one commits during his/her interview, employers often don't turn up with a positive response or a job offer. TimesJobs.com approaches some of the industry experts to find out those mistakes that any job seeker can avoid.  Poorly written resume  In order to stand out among the thousands of resumes that recruiters receive every day, a candidate's resume must represent the best that he/she has to offer and why they are right for the job. However, most job seekers spend tremendous energy, time, and effort to create an impactful resume, but send out multiple copies of the same to various recruiters instead of customising it for each position. For every job application, one should send a customised resume highlighting key strengths and capa
Read more

How Understanding Cloud Computing Saved a Million Dollars!

Image
  Ever wondered how a deeper understanding of Cloud Computing could not just be a technological advantage but a game-changer for your finances? As we dive into the transformative realm of the Cloud, we’ll explore its multifaceted benefits and how I aided a client in saving a whopping million dollars within a year, all thanks to the power of serverless computing. Whether you’re a tech enthusiast, an entrepreneur, or someone simply curious about Cloud Computing, this article promises a trove of insights for you. 1. My Revelation from the Module: While going through the recent module on Cloud Computing, I was astounded by the depth and the potential of the cloud. It’s not merely about storing data; it’s a paradigm shift in how we perceive and utilize technology. 2. The Cloud Computing Conundrum: So, what exactly is  Cloud Computing ? Imagine not having to own a physical storage device but still being able to access all your data from anywhere, anytime. That’s the magic of the cloud! It’s
Read more

How to create test account in moneybookers.com

If you want to test the Moneybookers integration without using your real money then you will need to create 2 test accounts. Unfortunately Moneybookers doesn't have a "sandbox" account like PayPal or Authorize.Net, so this process is a little trickier. Sign up for a Moneybookers "Business account". Do not use the same email you'll be using for your real account. Sign up for a Moneybookers "Personal account". Use a different email than the "Business account". Do not use the same email you'll be using for your real account. Contact Moneybookers and ask them to convert these 2 accounts to test accounts. It doesn't need to be a long email. Just something simple like: ----------------------------------------- We need you to turn 2 accounts to test accounts: "Buyer account": Email: buyer-email@domain.com Customer ID: <UR ID> "Merchant account": Email: merchant-email@domain.com Customer ID: <UR
Read more