mysql - 在 MySQL 中删除前缀

Question

起初我在添加前缀时有这段代码:

Dim sSQL As String
sSQL = ("UPDATE `" + cboJob.Text + "` SET `Line Number` = CONCAT('a',`Line Number`) WHERE `Line Number` LIKE '%-%'")
MyDB.ExecQuery(sSQL, "wellsfargo")

现在我的问题是如何删除我刚才添加的前缀“a”

Answer 1

 UPDATE your_table
 SET `Line Number` = substring(`Line Number`, 2)
 WHERE `Line Number` LIKE 'a%-%'