本文介绍在MySQL和MSSQL中处理字段名的两种方法：一种是判断字段名是否包含特定字符并在不含时追加'.00'；另一种是在字段名中查找特定字符的位置并根据位置进行截取或替换。
mysql
select
case instr(fieldname,'.')>0
when 1 then fieldname
else concat(cast(fieldname as char),'.00')
end as fieldname;
case instr(fieldname,'.')>0
when 1 then fieldname
else concat(cast(fieldname as char),'.00')
end as fieldname;
mssql
declare @temp nvarchar(50)
declare @index int
set @temp='asdfasf/asdfas'
select charindex('/',@temp)
set @index=charindex('/',@temp)
print @index
select case @index
when 8 then
substring(@temp,charindex('/',@temp)+1,len(@temp)-charindex('/',@temp)-1)
else
replace(@temp,'a','xxxx')
end as newfield
declare @index int
set @temp='asdfasf/asdfas'
select charindex('/',@temp)
set @index=charindex('/',@temp)
print @index
select case @index
when 8 then
substring(@temp,charindex('/',@temp)+1,len(@temp)-charindex('/',@temp)-1)
else
replace(@temp,'a','xxxx')
end as newfield
扫一扫
1712
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
