<div>
Maybe try <br />
<br />
update table1 SET assigned_user_id = TRIM(TRAILING '\n' FROM assigned_user_id)<br />

</div>


Maybe try

update table1 SET assigned_user_id = TRIM(TRAILING '\n' FROM assigned_user_id)


<div>
@DalHorinek it's still working<br />
<br />
And i've also tried below, and it's also not working:<br />
update table1 SET assigned_user_id = TRIM(TRAILING '\r\n' FROM assigned_user_id)<br />

</div>


@DalHorinek it's still working

And i've also tried below, and it's also not working:
update table1 SET assigned_user_id = TRIM(TRAILING '\r\n' FROM assigned_user_id)


<div>
I mean it's still NOT working
</div>


<div>
Wat about something like UPDATE table1 &nbsp;SET assigned_user_id=TRIM(REPL<wbr />ACE(REPLAC<wbr />E(assigned<wbr />_user_id, &quot;\n&quot;, &quot;&quot;), &quot;\t&quot;, &quot;&quot;));<br />
<br />
<br />
Also try it with simple select <br />
<br />
SELECT REPLACE(assigned_user_id, &quot;\n&quot;, &quot;&quot;) FROM table1 <br />
<br />
if it does anything
</div>


Wat about something like UPDATE table1  SET assigned_user_id=TRIM(REPLACE(REPLACE(assigned_user_id, "\n", ""), "\t", ""));


Also try it with simple select

SELECT REPLACE(assigned_user_id, "\n", "") FROM table1

if it does anything

<div>
Try this... <br />
<br />
UPDATE table_name SET column_name = REPLACE(column_name, CHAR(13), '');<br />

</div>


Try this...

UPDATE table_name SET column_name = REPLACE(column_name, CHAR(13), '');


<div>
<div class="content wysiwyg-content">
Hi Guys,<br />
<br />
I need a MySQL Syntax to remove &quot;new line&quot; character in a field.<br />
<br />
I've tried these 2 code, but it not working<br />
<br />
UPDATE table1 SET assigned_user_id=REPLACE(a<wbr />ssigned_us<wbr />er_id, '\r\n', '');<br />
UPDATE table1 SET assigned_user_id=REPLACE(a<wbr />ssigned_us<wbr />er_id, '\n', '');<br />
<br />
Please help. Thanks.
</div>
</div>


Hi Guys,

I need a MySQL Syntax to remove "new line" character in a field.

I've tried these 2 code, but it not working

UPDATE table1 SET assigned_user_id=REPLACE(assigned_user_id, '\r\n', '');
UPDATE table1 SET assigned_user_id=REPLACE(assigned_user_id, '\n', '');

Please help. Thanks.

Remove &quot;new line&quot;character

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

Remove &quot;new line&quot;character

Remove "new line"character