Remove 5th position character From column using MYSQL Query
You can use string functions like LEFT and RIGHT, and CONCAT the final result.




create table tbl(`Order` varchar(20));
insert into tbl values
('PRSW000000001'),
('PRSW000000002'),
('PRSW000000003'),
('PRSW000000004');






update tbl
set `Order` = concat(left(`Order`, 4), right(`Order`, length(`Order`) - 5));






select * from tbl;



| Order        |
| :----------- |
| PRSW00000001 |
| PRSW00000002 |
| PRSW00000003 |
| PRSW00000004 |



dbfiddle here