mysql 개행문자 엔터등 삭제 > 질문답변

• 목록

UPDATE swearword SET swearword = REPLACE(swearword, '\r\n','');
UPDATE swearword SET swearword = REPLACE(swearword, '\n','');
UPDATE swearword SET swearword = REPLACE(swearword, CHAR(13),'');


중복 데이터 삭제
DELETE n1 FROM test.board n1, test.board n2 WHERE n1.idx > n2.idx AND n1.user_name = n2.user_name;