Remove 5th position character From column using MYSQL Query I want remove 5th character from column using MYSQL Query.

My column lokks like

PRSW000000001
PRSW000000002
PRSW000000003
PRSW000000004
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