MySQL删除所有字段的前两个字符 [英] MySQL Remove first two characters of all fields

问题描述

我有一些看起来像这样的数据:

I have some data that looks like this:

C:10
R:200
N/A
E:3
N/A
N:77

我正在尝试删除每行的前两个字符，并使用N/A跳过行.我一直在尝试找出如何使用SUBSTRING来做到这一点，但是没有运气.

I'm trying to remove the first two characters for each row, and skip the rows with N/A I've been trying to figure out how to do this with SUBSTRING but have had no luck.

UPDATE d1
SET d1_val = SUBSTRING(d1_val, 1, LENGTH(d1_val)2)

推荐答案

尝试

UPDATE d1
SET d1_val = SUBSTRING(d1_val, 3)
WHERE d1_val <> 'N/A'

这篇关于MySQL删除所有字段的前两个字符的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！