A program or code, can put A column there contains B clear away all the column data, mainly on the relationship between the column selection contains B column data, need the results soon,

CodePudding user response:

SQL statements can be realized, the replace used three functions, right, left

 SELECT the replace (field name, the right (left (field name, 5), 3), ' ') FROM the table name