Removing line breaks and tabs in a MySQL column

Removing line breaks and tabs in a MySQL column

Sometimes it happens that you have unwanted tabs, line breaks, paragraphs, etc. in a table column. With the following code snippet you can clean the value of the column quickly:

[sql]update mytable
set mycolumn = REPLACE(REPLACE(REPLACE(mycolumn, ‘t’, ”), ‘r’, ”), ‘n’, ”)[/sql]

Helpmonks All-in-one Customer Service Platform
How to write an engaging email subject line

Email open rates are perhaps the most widely recognized email marketing metrics out there. 1 in 3 people open up emails purely based on what is in the subject line. Crafting the perfect email subject line can be daunting, and the last thing you want to do is deter your readers because…

Helpmonks All-in-one Customer Service Platform
New in Helpmonks — October 2017

The last few weeks have been busy here at Helpmonks. We all gathered for a team meeting in Germany, spent a great time together and also managed to release many new options to enhance your productivity in Helpmonks. Here are some of the highlights: Sort Sorting is now available in…

Helpmonks All-in-one Customer Service Platform
Customer Service Experience: A Guide for Small Business Owners

84% of customers agree that customer service is one of the most important factors that they take into consideration when they're deciding whether or not to buy from a company. Alone, this proves just how impactful and important customer service experience is to today's customers. That's why we're talking about…

Helpmonks All-in-one Customer Service Platform
OpenBD and MongoDB: Can't get easier then this

I'm currently working on a project that uses MongoDB (yes, that's the awesome NoSQL database everyone talks about). Now, my favorites language of choice (CFML) and especially my favorite open source CFML engine OpenBD, has support for MongoDB built in which makes it a snap to use for any ColdFusion…

Helpmonks All-in-one Customer Service Platform
22 of the best email subject lines for your email newsletter

Are you struggling with ideas for your next email subject line or blog post? We get it - It can be hard to know what to say in the space of fewer than 15 words, especially if you can't think of a way to condense your email into a single…

Helpmonks All-in-one Customer Service Platform
MySQL replication - Query caused different errors on master and slave

MySQL replication works quite reliable most of the time. But from time to time, especially if you change network, servers or the master has gone away the slave will get in a "weird" state. Today, I've encountered the following error message on one of the slaves; Query caused different errors…

Go back

Trusted by over 2,000 organizations with millions of emails

Helpmonks helps us answer customer emails at lighting speed
We couldn't do our job without Helpmonks!
Helpmonks, the best thing since sliced bread
Excellent option for collaborating email amongst your team
A good platform that is here to grow and help you grow
Helpmonks is a great tool that our company utilizes and depends on
Great shared inbox for the team
Fantastic email support service for any business
Easy to navigate and catalog data for specific users
Solid Helpdesk software w/ responsive customer support
A really good solution to manage customer support mailbox
Good support, useful features
Hear from other customers what they say about Helpmonks

One more thing...

Helpmonks gives you the ability tocollaborate as a groupin your shared mailbox, features aTeam To-Do App, powerfulCustomer Relationship Management (CRM)capabilities, integratedLive-Chatand Email Marketing Tools for email newsletter and automated email campaigns, collision detection, email tracking, reminders, mentions, custom fields, custom applications, customer satisfaction ratings, Single-Sign-On (SSO) & SAML authentication, Trello, Zapier, Slack, an API, and much more.

Check outthe complete feature listor sign up for afree 30-day shared inbox trial now