> ## Content Index
> Fetch the complete content index at: https://helpmonks.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Removing line breaks and tabs in a MySQL column
- URL: https://helpmonks.com/blog/removing-line-breaks-and-tabs-in-a-mysql-column/
- Published: 2012-06-09T00:00:00.000Z
- Updated: 2026-04-04T01:57:48.000Z
- Description: 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
- Author: Nitai
- Tags: email marketing

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\]