MariaDB 10.6

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table t230104a (
  id int not null auto_increment primary key
, vc varchar(20)
, tx text
);

insert into t230104a(vc,tx) values
('測試資料' , '2011.01.01 依2011薪資調整表作業薪調'),
('一個空白', ' '),
('三個空白', '   '),
('五個空白', concat(char(10),'     ',char(10))),
('一個空白列', char(10)),
('三個空白列', concat(char(10),char(10),char(10))),
('五個空白列', concat(char(10),char(10),char(10),char(10),char(10))),
('頭尾空白', ' 2014.08.01 勞保局調整勞保保費 ');

Records: 8  Duplicates: 0  Warnings: 0


delete from t230104a 
where id in (
    select id from t230104a 
      where length(replace(replace(tx,' ',''),char(10),'')) = 0
)
update t230104a
set tx = trim(tx);

Rows matched: 2  Changed: 1  Warnings: 0


select *
from t230104a;


id
vc
tx


1
測試資料
2011.01.01 依2011薪資調整表作業薪調

8
頭尾空白
2014.08.01 勞保局調整勞保保費

id	vc	tx
1	測試資料	2011.01.01 依2011薪資調整表作業薪調
8	頭尾空白	2014.08.01 勞保局調整勞保保費