Replace SQL with carriage return / line feed in field

From , 3 Years ago, written in SQL, viewed 53 times.

--替换回车
UPDATE TABLE_NAME
SET field_name=REPLACE(field_name,CHR(13),'')
WHERE INSTR(field_name,CHR(13))>0 
--替换换行
UPDATE TABLE_NAME
SET field_name=REPLACE(field_name,CHR(10),'')
WHERE INSTR(field_name,CHR(10))>0 
 
TABLE_NAME:表名
field_name:列名
//SQL/1231

Reply to "Replace SQL with carriage return / line feed in field"

Here you can reply to the paste above

Author What's your name?

Title Give your paste a title.

Language What language is your paste written in?

Your paste Paste your paste here

Create Shorturl Create a shorter url that redirects to your paste?

Private Private paste aren't shown in recent listings.

Delete After When should we delete your paste?

Spam protection Type in the letters

https://burned.cc - Burn After Reading Website

Pastebin.vip

Replace SQL with carriage return / line feed in field

Reply to "Replace SQL with carriage return / line feed in field"